Transportation Intelligence

Region Prompt

This prompt provides the ability to filter facts by the source location and destination location dimensions. This prompt is designed to be used exclusively in dashboards where slicing the metrics by location is applicable. This file is located in the catalog in /Shared Folders/FTI New Prompts/Region Prompt

Prompt Column

Based on Dimension

Definition

Source Region

"- Shipment Source Geography Dimensions"."Region"

This prompted column displays the list of source regions; that is source location dimension records grouped at the level of region.

Source Country

"- Shipment Source Geography Dimensions"."Country"

 This prompted column displays the list of source countries; that is source location dimension records grouped at the level of country.

Source Province

"- Shipment Source Geography Dimensions"."Province"

This prompted column displays the list of source provinces; that is source location dimension records grouped at the level of province.

Source Location

"- Shipment Source Geography Dimensions"."Location XID"

This prompted column displays the list of source location; that is source location dimension records grouped at the level of location XID.

Destination Region

"- Shipment Destination Geography Dimensions"."Region"

This prompted column displays the list of destination regions; that is destination location dimension records grouped at the level of region.

Destination Country

"- Shipment Destination Geography Dimensions"."Country"

This prompted column displays the list of destination countries; that is destination location dimension records grouped at the level of country.

Destination Province

"- Shipment Destination Geography Dimensions"."Province"

 This prompted column displays the list of destination provinces; that is destination location dimension records grouped at the level of province.

Destination Location

"- Shipment Destination Geography Dimensions"."Location XID"

This prompted column displays the list of destination location; that is destination location dimension records grouped at the level of location XID.

 

Related Topics