About Transportation Operational Intelligence

The Transportation Operational Intelligence subject area allows you to access transactional data present in OTM to create reports and data visualization projects.

Transportation Operational Intelligence is available as a subject area under Transportation Intelligence > Ad Hoc Query > Analysis > Transportation Operational Intelligence.

Subject Area

The Transportation Operational Intelligence subject area has three main sections, each catering to a different component:

Shipment Operational Analysis
Order Release Operational Analysis
Order Base Operational Analysis
Invoice Operational Analysis
Shipment Tracking Events Analysis
Order Release Tracking Event Analysis

Shipment Operational Analysis

The Shipment table in OLTP has been broken into Dimension shipment and Fact Shipment, and the other connections have been made to the Fact Shipment. The important directories that have been included are:

Shipment Facts (Shipment table)
Shipment Dimension (Shipment table)
Shipment Status Dimension (Shipment status, Status type, status value tables)
Shipment Source and Destination locations (Location + Country + Region tables)
Shipment fiscal and time dimensions (Time table)
Shipment Servprov (Service Provider table)
Shipment Transport mode (transport mode table)
Shipment Perspective(Perspective table)
Shipment domain (Domain table)

Order Release Operational Analysis

The Order Release table in OLTP has been broken into Dimension Order release and Fact Shipment, and the other connections have been made to the Fact Order Release. The important directories that have been included are:

Order Release Facts (Order Release table)
Order Release Dimension (Order Release table)
Order Release Status Dimension (Order Release status, Status type, status value tables)
Order Release Source and Destination locations (Location + Country + Region tables)
Order Release Fiscal and time dimensions (Time table)
Order Release Servprov (Service Provider table)
Order Release Transport mode (transport mode table)
Order Release domain (Domain table)

Order Base Operational Analysis

The data present in the folders follow a star schema where parent-child (order base-order base line) relation is maintained as in the database. Following are the folders available:

Order Base Facts
Order Base Insert Time Dimensions
Order Base Insert Time Fiscal Dimensions
Order Base Domain Dimensions
Order Base Itinerary Dimensions
Order Base Lane Dimensions
Order Base Rate Offering Dimensions
Order Base Rate Record Dimensions
Order Base Service Provider Dimensions
Order Base Transport Mode Dimensions
Order Base Equipment Group Dimensions
Order Base Dimensions
Order Base Line Dimensions

Invoice Operational Analysis

The Invoice table in OLTP has been broken into Dimension Invoice and Fact Invoice , and the other connections have been made to the Fact Invoice . The important directories that have been included are:

Invoice Facts (Invoice table)
Invoice Dimension (Invoice table)
Invoice Status Dimension (Invoice status, Status type, status value tables)
Invoice Source and Destination locations (Location + Country + Region tables)
Invoice Fiscal and time dimensions (Time table)
Invoice Servprov (Service Provider table)
Invoice domain (domain table)

Shipment Tracking Events Analysis

You can use the data present in the following folders to enable transactional reporting on tracking events related to shipments.

Shipment Tracking Events Facts
Shipment Tracking Event Period Dimensions
Shipment Tracking Event Fiscal Period Dimensions
Shipment Tracking Event Source Geography Dimensions
Shipment Tracking Event Destination Location Dimensions
Shipment Tracking Event Domain Dimensions
Shipment Tracking Event Lane Dimensions
Shipment Tracking Event Transport Mode Dimensions
Shipment Tracking Event Service Provider Dimensions
Shipment Tracking Event Perspective Dimensions
Shipment Tracking Event Equipment Group Dimensions
Shipment Tracking Event Dimensions

Order Release Tracking Event Analysis

You can use the data present in the following folders to enable transactional reporting on tracking events related to shipments.

Order Release Tracking Event Facts
Order Release Tracking Event Period Dimensions
Order Release Tracking Event Fiscal Period Dimensions
Order Release Tracking Event Source Location Dimensions
Order Release Tracking Event Destination Location Dimensions
Order Release Tracking Event Plan From Dimensions
Order Release Tracking Event Plan To Dimensions
Order Release Tracking Event Itinerary Dimensions
Order Release Tracking Event Lane Dimensions
Order Release Tracking Event Service Provider Dimensions
Order Release Tracking Event Transport Mode Dimensions
Order Release Tracking Event Domain Dimensions
Order Release Tracking Event Status Code Dimensions
Order Release Tracking Event Reason Code Dimensions
Order Release Tracking Event Responsible Party Dimensions
Order Release Tracking Event Refnum Qualifier Dimensions
Order Release Tracking Event Dimensions

Loading Data

To load and unload scenario data to Logistics Network Modeling, use the modeling scenario actions of Send Data to Analytics and Unload Data from Analytics.

Dashboard

A Dashboard is a collection of performance metrics reflecting common strategic goals. The metrics are displayed as various key performance indicators formatted as charts, graphs, tables, cross-tabs, and status indicators. There are multiple tabs organizing the metrics. Dashboard comes pre-defined with standard metrics. If you have access to Logistics Network Modeling and you have the Logistics Network Modeling Dashboard set as a default dashboard in user preferences, this page can be accessed via Transportation Intelligence > Dashboard.

Note: A user can only have one default dashboard set at a time. As a result, a single user cannot have both an Transportation Intelligence (TI) default dashboard and a Logistics Network Modeling default dashboard. To view both the TI and Logistics Network Modeling dashboards, create one user with access to LNM and set their dashboard preference to point to the LNM dashboard. Then, create a second user with access to TI and set their dashboard preference to point to the TI dashboard.

Ad Hoc Query

This component allows creation of reports on the fly. For details on Ad Hoc Queries, click the help icon. This page is accessed via Transportation Intelligence > Ad Hoc Query. Then under Analysis and Interactive Reporting select Analysis > Logistics Network Modeling Intelligence. You should have an Oracle Analytics license to work in this page.

Catalog

Any queries that you have created and saved appear under Catalog > My Folders and are only be available to you.

Any queries that the TI administrator created and saved appear under Catalog > Shared Folders. Any TI user can access these queries.

Important! All user-defined reports and dashboards must be created inside the shared/Custom folder or a sub-folder. Defining reports and dashboards inside the shared/Custom folder will ensure your user-defined reports and dashboards are retained during upgrades. All out-of-the-box folders are read-only so you cannot save content in folders other than shared/Custom. If you try to save content outside of shared/Custom, you will see an error which may be one of the following: "Access denied for user to path..." or "Can't save in root folder.".