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