Transportation Intelligence
Logistics Network Modeling Dashboard
The LNM Dashboard uses the Logistics Network Modeling Intelligence subject area and allows selection of project GIDs via a prompt and comparison of scenarios under this project via different analyses. This dashboard is available as a preferred dashboard in the OTM/GTM user preferences.
This dashboard report is located in the catalog in Shared Folders/FTI Reports/_portal/Logistics Network Modeling Dashboard
Prompt
The Logistics Network Modeling dashboard uses the ProjectsPrompt. This prompt is located in the catalog in Shared Folders/LNM Prompts
ProjectsPrompt
This prompt provides the ability to filter facts by project ID.
Prompt Column |
Based on Dimension |
Default Value |
---|---|---|
Projects |
"Modeling Project Dimensions"."Project GID" |
(All Column Values) |
Scenario Graphs Tab
This report captures the count and cost information for Logistics Network Modeling project and scenarios. It uses the ProjectsPrompt.
CostGraphs
The report for this section is located in the catalog in /Shared Folders/_portal/Logistics Network Modeling Dashboard/CostGraphs
Total Shipment Count Graph
The Total Shipment Count graph shows the total shipment count per scenario.
Column |
Definition |
Metadata Mapping |
---|---|---|
Scenario ID |
The scenarios for the selected project or projects. |
"Modeling Scenario Dimensions"."Scenario GID" |
Total Shipment Count |
The total shipment count for each scenario ID. |
"Modeling Shipment Facts"."Total Shipment Count" |
Total Cost Graph
The Total Cost graph shows the cost per shipment for each scenario.
Column |
Formula |
Metadata Mapping |
---|---|---|
Scenario GID |
NA |
"Modeling Scenario Dimensions"."Scenario GID" |
Total Cost |
NA |
"Modeling Shipment Facts"."Total Actual Cost" |
Cost per Shipment |
"Modeling Shipment Facts"."Total Actual Cost"/"Modeling Shipment Facts"."Total Shipment Count" |
NA |
Cost per Order Graph
The Cost per Order graph shows the cost per order release for each scenario.
Column |
Formula |
Metadata Mapping |
---|---|---|
Scenario GID |
NA |
"Modeling Scenario Dimensions"."Scenario GID" |
Total Cost |
NA |
"Modeling Shipment Facts"."Total Actual Cost" |
Cost per Order |
"Modeling Shipment Facts"."Total Actual Cost"/"Modeling Shipment Facts"."Num Order Releases" |
NA |
Cost per Shipment Graph
The Cost per Shipment graph shows the cost per shipment for each scenario.
Column |
Formula |
Metadata Mapping |
---|---|---|
Scenario GID |
NA |
"Modeling Scenario Dimensions"."Scenario GID" |
Total Cost |
NA |
"Modeling Shipment Facts"."Total Actual Cost" |
Cost per Order |
"Modeling Shipment Facts"."Total Actual Cost"/"Modeling Shipment Facts"."Total Shipment Count" |
NA |
DetailMetricsTable
The report for this section is located in the catalog in /Shared Folders/_portal/Logistics Network Modeling Dashboard/DetailMetricsTable
The Scenario Summary Table shows details for each scenario as listed below.
Column |
Metadata Mapping |
Formula |
---|---|---|
Scenario XID |
"Modeling Scenario Dimensions"."Scenario XID" |
NA |
Actual Transport Mode GID |
"Modeling Shipment Transport Mode Dimensions"."Actual Transport Mode GID" |
NA |
Actual Service Provider GID |
"Modeling Shipment Transport Mode Dimensions"."Actual Transport Mode GID" |
NA |
Total Shipment Count |
"Modeling Shipment Facts"."Total Shipment Count" |
NA |
Cost per Order |
NA |
"Modeling Shipment Facts"."Total Actual Cost"/"Modeling Shipment Facts"."Num Order Releases" |
Cost per hundred weight |
NA |
"Modeling Shipment Facts"."Total Actual Cost"/"Modeling Shipment Facts"."Total Weight" |
Total Cost |
"Modeling Shipment Facts"."Total Actual Cost" |
NA |
Total Weight |
"Modeling Shipment Facts"."Total Weight" |
NA |
Weight Utilization |
"Modeling Shipment Facts"."Weight Utilization" |
NA |
Total Orders |
"Modeling Shipment Facts"."Num Order Releases" |
NA |
Orders per Shipment |
NA |
"Modeling Shipment Facts"."Num Order Releases"/"Modeling Shipment Facts"."Total Shipment Count" |
Average stops |
NA |
"Modeling Shipment Facts"."Num Stops"/"Modeling Shipment Facts"."Total Shipment Count" |
Average time |
NA |
"Modeling Shipment Facts"."Total Hours"/"Modeling Shipment Facts"."Total Shipment Count" |
Scenario Summary Tab
The report for this section is located in the catalog in /Shared Folders/_portal/Logistics Network Modeling Dashboard/DetailMetricsTable
The Scenario Summary tab shows details for each scenario as listed below.
DetailMetricsTable
Column |
Based on Dimension |
Formula |
---|---|---|
Scenario XID |
"Modeling Scenario Dimensions"."Scenario XID" |
NA |
Total Shipment Count |
"Modeling Shipment Facts"."Total Shipment Count" |
NA |
Total Cost |
"Modeling Shipment Facts"."Total Actual Cost" |
NA |
Cost per Order |
NA |
"Modeling Shipment Facts"."Total Actual Cost"/"Modeling Shipment Facts"."Num Order Releases" |
Cost per Shipment |
"Modeling Shipment Facts"."Total Actual Cost"/"Modeling Shipment Facts"."Total Shipment Count" |
|
Cost per hundred weight |
NA |
"Modeling Shipment Facts"."Total Actual Cost"/"Modeling Shipment Facts"."Total Weight" |
Total Weight |
"Modeling Shipment Facts"."Total Weight" |
NA |
Weight Utilization |
"Modeling Shipment Facts"."Weight Utilization" |
NA |
Total Orders |
"Modeling Shipment Facts"."Num Order Releases" |
NA |
Orders per Shipment |
NA |
"Modeling Shipment Facts"."Num Order Releases"/"Modeling Shipment Facts"."Total Shipment Count" |
Average stops |
NA |
"Modeling Shipment Facts"."Num Stops"/"Modeling Shipment Facts"."Total Shipment Count" |
Average time |
NA |
"Modeling Shipment Facts"."Total Hours"/"Modeling Shipment Facts"."Total Shipment Count" |
Scenario Stops Tab
The report for this section is located in the catalog in /Shared Folders/_portal/Logistics Network Modeling Dashboard/ScenarioComparison
The Scenario Stops tab shows details for each scenario as listed below.
ScenarioComparison
Column |
Metadata Mapping |
---|---|
Project GID |
"Modeling Scenario Dimensions"."Project Gid" |
Scenario GID |
"Modeling Scenario Dimensions"."Scenario GID" |
Total Shipment Count |
"Modeling Shipment Facts"."Total Shipment Count" |
Number of Stops |
"Modeling Shipment Facts"."Num Stops" |
Actual Service Provider GID |
"Modeling Shipment Transport Mode Dimensions"."Actual Transport Mode GID" |