Configuration

Business intelligence refers to the following optional product offerings:

• Transportation Intelligence (TI)
• Global Trade Intelligence (GTI)

TI and GTI business intelligence solutions are designed to enable strategic and tactical analysis of the various aspects of the trade and transportation business processes and to aid decision making.

Business intelligence solutions are developed using the Oracle Analytics Server (for the core analytics metadata and dashboard reports) and Oracle Data Integrator (for the core Extract, Transform, Load process) products. The following section provides some details on the configuration and use of these modules. For more information on these products, refer to the Transportation Intelligence and Global Trade Intelligence Reference Guide help topics.

The TI and GTI product options are disabled by default in the Cloud. By default the Extraction, Transformation, and Load (ETL) processes are disabled so the corresponding analytic database tables will be empty. You will receive the following warning if you click on one of the business intelligence Dashboard links "Business Intelligence is not currently licensed or installed on the server."

You will need to do the following in order to enable these product options. One or both of the following properties need to be set in order to enable the Oracle Analytics product options. Please refer to the Custom Properties section of this document for more detail on how to set properties. These properties should be set in the “CUSTOM” property set.

• TI property: ALLOW_ADVANCED_ANALYTICS=true
• GTI property: isAllowedGTIAnalytics=true

Once these properties are enabled the ETL will run automatically on a daily basis. The frequency of these ETLs is not configurable by the customer. In order to have visibility into the ETL process, the following property should be set. A summary of each ETL process will be sent to this email address when the process completes.

• glog.odi.email.to.address=[e-mail]

It is possible to configure analytics using Oracle Analytics Server (OAS). The user interface for OAS is accessed via menu option Transportation Intelligence > Administration.

where <servicename> and <identity-domain-name> are the values that were specified during provisioning.

Users login OAS using the Transportation and Global Trade Management User ID/password.

Note: Currently you must use the Transportation and Global Trade Management User ID (i.e. DBA.ADMIN), not the Transportation and Global Trade Management username. You also must first grant the User the BI Roles "BIAdministrators" and "BIAuthors". BI Roles are administrated using the Transportation and Global Trade Management User Manager. This page is located at Configuration and Administration > User Management > User Manager.

Note: Important! Before creating any reports or dashboards, you must create a catalog folder named "Custom" inside the existing "Shared Folders" folder. All reports and dashboards must be created inside this folder or a sub-folder. Defining reports and dashboards inside the “Custom” folder will ensure your customer-defined reports and dashboards are retained during future upgrades.

Note: Previously, triggering ETL wasn't allowed if a session was already running. Now, there's an extra clause to verify if the "Load Time" of the latest ETL is more than 2 days. If the latest session is running for more than 2 days, a concurrent ETL can be triggered. This will avoid issues which might occur due to a stale ETL session, or an ETL session getting stuck.