Transportation Intelligence
Main Dashboard: Utilization
This tab displays the KPIs related to key utilization details of shipments. The actual value of the KPI is compared against the target value with a two-color gauge showing the status of the comparison.
The report for this tab is located in the catalog in /Shared Folders/FTI Reports/_portal/Main Dashboard/Utilization Tab
Metric |
Definition |
Formula |
Threshold (Stop Light) Definition |
---|---|---|---|
Weight Utilization |
Total weight utilization of shipments as calculated in OTM. |
case when ("- Shipment Targets"."Weight Utilization Target" is NULL or "- Shipment Targets"."Weight Utilization Target" = 0) and ("- Shipment Facts"."Weight Utilization" is NULL or "- Shipment Facts"."Weight Utilization" = 0) then 100 else ("- Shipment Targets"."Weight Utilization Target") end |
Weight utilization is greater than 100% of target value then green. Weight utilization is less than 100% of target value then red. If no data exists for the selected criteria then gray. |
Volume Utilization |
Total volume utilization of shipments as calculated in OTM. |
case when ("- Shipment Targets"."Volume Utilization Target" is NULL or "- Shipment Targets"."Volume Utilization Target" = 0) and ("- Shipment Facts"."Volume Utilization" is NULL or "- Shipment Facts"."Volume Utilization" = 0) then 100 else ("- Shipment Targets"."Volume Utilization Target") end |
Volume utilization is greater than 100% of target value then green. Volume utilization is less than 100% of target value then red. If no data exists for the selected criteria then gray. |
Related Topics
Chapter 3. Oracle Analytics Server
Data Flow to Transportation Intelligence
Business Intelligence Applications
Business Intelligence Roles and User Manager
Transportation Intelligence Write-back Dashboards
How to Provide Access to Transportation Intelligence for a User