Transportation Intelligence
City and Province Prompt
This prompt provides the ability to filter facts by the Oracle Cloud Map Service columns. This prompt is used exclusively in the Maps tab of Main dashboard. This file is located in the catalog in /Shared Folders/FTI New Prompts/City and Province Prompt – Map Analysis
Prompt Column |
Based on Dimension |
Definition |
---|---|---|
Source Province |
"- Shipment Map Dimensions"."Source Province" |
This prompted column displays a drop-down list of source location province codes. |
Source City ID |
"- Shipment Map Dimensions"."Source City ID" |
This prompted column displays a drop-down list of source location city names appended with the respective province codes. |
Destination Province |
"- Shipment Map Dimensions"."Destination Province" |
This prompted column displays a drop-down list of destination location province codes. |
Destination City ID |
"- Shipment Map Dimensions"."Destination City ID" |
This prompted column displays a drop-down list of destination location city names appended with the respective province codes. |
Related Topics
Chapter 3. Oracle Analytics Server