Transportation Operational Intelligence Data Visualization

The TI Data Visualization project uses the Transportation Intelligence subject area and displays various service provider metrics.

This project is located in the catalog in Shared Folders/FTI Data Visualization.

Business Spotlight

This project is located in the catalog in Shared Folders/FTI Data Visualization/Business Spotlight

The DV project contains the following graphs:

Shipment - Enroute

This graph shows the number of OTM invoices for each Status Value for the Status Type of ENROUTE.

OLTP tables used for data are SHIPMENT_STATUS, STATUS_VALUE, and STATUS_TYPE. For the status type of ENROUTE, the graph displays all status value XIDs except for ENROUTE_COMPLETED.

Shipment - Secure Resources

This graph shows the number of OTM invoices for each Status Value for the Status Type of SECURE RESOURCES.

OLTP tables used for data are SHIPMENT_STATUS, STATUS_VALUE, and STATUS_TYPE. For the status type of SECURE RESOURCES, the graph displays all status value XIDs except for the following:

• SECURE RESOURCES_ACCEPTED
• SECURE RESOURCES_PICKUP NOTIFICATION

Invoice - Approval

This graph shows the number of OTM invoices for each Status Value for the Status Type of APPROVAL.

OLTP tables used for data are INVOICE_STATUS, STATUS_VALUE, and STATUS_TYPE. For the status type of APPROVAL, the graph displays all status value XIDs except for the following:

• APPROVAL_APPROVED_AUTO
• APPROVAL_APPROVED_ADDENDUM
• APPROVAL_APPROVED_MANUAL
• APPROVAL_APPROVED_REJECTED

Order Release - Planning

This graph shows the number of OTM shipments for each Status Value for the Status Type of PLANNING.

OLTP tables used for data are ORDER_RELEASE_STATUS, STATUS_VALUE, and STATUS_TYPE. For the status type of PLANNING, the graph displays all status value IDs except for PLANNING_EXECUTED – FINAL.

Sustainability

This project is located in the catalog in Shared Folders/FTI Data Visualization/Sustainability DV.

This workbook captures metrics related to carbon (CO2) emission and other green house gases emission (CO2e). This is created using Transportation Operational Intelligence subject area where the planned and the actual emissions are displayed based on real-time data. These emissions are aggregated by month and transport mode.

Following are the columns used from the OLTP shipment table for data.

Column Name	Description
PLANNED_CO2_EMISSION	CO2 emissions recorded while planning the shipment
PLANNED_CO2_EMISSION_UOM	Unit of Measure
PLANNED_CO2_EMISSION_BASE	Planned CO2 emissions in base unit of measure. (LB)
ACTUAL_CO2_EMISSION	Actual CO2 emissions for the shipment.
ACTUAL_CO2_EMISSION_UOM	Unit of Measure
ACTUAL_CO2_EMISSION_BASE	Actual CO2 emissions for the shipment in base unit of Measure (LB)
PLANNED_CO2_EQ_EMISSION	EQ - equivalent emissions
PLANNED_CO2_EQ_EMISSION_UOM	Unit of Measure
PLANNED_CO2_EQ_EMISSION_BASE	EQ - equivalent emissions
ACTUAL_CO2_EQ_EMISSION	EQ - equivalent emissions
ACTUAL_CO2_EQ_EMISSION_UOM	Unit of Measure
ACTUAL_CO2_EQ_EMISSION_BASE	EQ - equivalent emissions

Following are the metrics captured in this workbook:

• Actual CO2 Emission
• Actual CO2 Emission Base
• Planned CO2 Emission
• Planned CO2 Emission Base
• Actual CO2 Eq Emission
• Actual CO2 Eq Emission Base
• Planned CO2 Eq Emission
• Planned CO2 Eq Emission Base
• Distance Base 
• Weight Distance =  Total Weight Base * Distance Base
• Freight Intensity
• Planned Freight Intensity = Planned CO2 Eq Emission Base /  Weight Distance
• Actual Freight Intensity = Actual CO2 Eq Emission Base /  Weight Distance

The following visualizations are available in this workbook:

Emission Summary

This visualization displays a summary of Actual CO2 Emission, Planned CO2 Emission, Actual CO2e Emission, and Planned CO2e Emission for the past six month. Also, it captures transportation mode wise CO2 and CO2e emission.

Planned and Actual Emission

This is a tabular visualization which captures the metrics Weight, Weight Distance, CO2 and CO2e emission, and Freight Intensity.

Freight Emission Intensity Month on Month

This visualization captures month wise planned and actual freight intensity for the last six months.

Freight Emission Intensity

This visualization captures freight emission distribution based on sankey visualization.

Using as the Home Landing Page

You can create an enhanced workbench using this DV project and set it to show instead of the springboard. This section contains detailed steps to turn your home page into a spotlight of your business.

Setting up the DV Project

1. Login as the DBA.ADMIN user.
2. Go to Transportation Intelligence > Catalog.
3. In the Folders pane, go to Shared Folders > FTI Data Visualization.
4. Click on the "Business Spotlight" DV Project and in the Tasks pane, select Copy.
5. In the Folders pane, go to Custom and in the Tasks pane, click Paste. The DV project is copied to the Custom folder where you can edit it and make changes. Also in this location, the project is not overwritten during an upgrade.
6. Open the Business Spotlight project that you just copied into the Custom folder.
7. Click on the Menu icon on top right corner ( three vertical dots) and select Data Actions.
8. Update the <OTM_WEB_SERVER_WITHP> in the URL box for all the three data actions with web server host name along with protocol as shown below.
   1. Invoice Results
   2. Order Release Results
   3. Shipment Results

   <OTM_WEB_SERVER_WITHP> signifies webserver hostname with protocol. Current PageURL is in the format <Protocol>://<WEB_SERVER>/dv/<OTM_WEB_SERVER_WITHP> replace with <Protocol>://<WEB_SERVER> of the current page or in case of malformed URL -> In the OTM URL with format <Protocol>://<WEB_SERVER>/GC3/..  use the <PROTOCOL>://<WEB_SERVER>

9. Save the "Business Spotlight" workbook in the /Shared Folders/Custom
10. Test the actions by clicking on any of the data points, e.g.: Shipment Enroute Chart, and right click on ENROUTE_ENROUTE.
11. Then select Shipment Results Action. This action should redirect to OTM screen with shipments having ENROUTE_ENROUTE value for ENROUTE status type.

Note:  By default, DBA.ADMIN has access to the Transportation Operational Intelligence subject area. The "Business Spotlight" DV Workbook can be edited only if the user has access the Operational Intelligence Subject Area.

Note: After the changes, customer can take a back-up of the updated project by using the Archive utility.

Creating the Workbench

Next, you create an enhanced workbench layout that contains your Business Spotlight DV project.

1. Go to Configuration and Administration > User Configuration > Enhanced Workbench.
2. Click Create Layout.
3. Enter a Layout ID.
4. Select the WORKBENCH DEFAULT logic configuration.
5. Select the Auto Refresh checkbox and set the Auto Refresh Interval to 5 minutes.
6. Click OK to create the layout.
7. To define a new pane, hover over the Layout Configuration icon to see the content editor menu and click Add Content.
8. Select a Component Type of Data Visualization.
9. Enter a Tab Name and Procheckbox (for example, /@Catalog/shared/Custom/Business_Spotlight). And click OK.
10.  Click INSERT ICON (Done Editing).

Setting as the Home Landing Page

Finally, you set your user preference to use the new workbench layout as your home page.

1. Go to Preferences > User Preferences.
2. Edit the user preference that is used by your domain.
3. Select a Name of Home Workbench Layout ID.
4. Select a Value of the workbench layout ID you created above.
5. Click Save and Finished.
6. Sign out and then back into OTM to apply the user preference. When you log in, you see that the Business Spotlight workbench is now your home page.