3. Business Intelligence Server

The Oracle Analytics Server in the Global Trade Intelligence solution is comprised of the Oracle Analytics Server suite that hosts the Global Trade Intelligence specific metadata and the dashboard components.

This chapter describes the details of the Global Trade Intelligence metadata and the dashboards.

Variables

Following is the list of variables available in the Global Trade Intelligence metadata.

Variable	Type	Description
CURRENT DATE	Dynamic	Stores the current date during the user’s active session.
UNITS OF MEASURE	Dynamic	Stores the UOM that the user defined in user preferences.
LOCALE	Dynamic	Stores the language and locale information of the user currently logged into Global Trade Management.
GET_PARAM_SET	Dynamic	Stores the parameter set of the user currently logged into Global Trade Management.
TR_CURRENT_WEEK	Dynamic	Stores translated value of “Current Week” string.
TR_WEEK	Dynamic	Stores translated value of “Week” string.
TR_TARGET_VALUE	Dynamic	Stores translated value of “Target Value” string.
BI_APP	Dynamic	Stores the value of the business intelligence application the user is assigned in Global Trade Management.
GTI_DEFAULT_DATE	Static	Stores the default date value which is used to replace null values in date columns of GTI tables.

Global Trade Management Subject Area

The Global Trade Intelligence subject area is structured into multiple analysis folders one for each Global Trade Management business object (trade transaction, trade transaction line, etc.). Each analysis folder then includes one facts folder and multiple dimensions folders. It is important to note that only compatible dimensions (and columns underneath) are available in each analysis folder. All columns under the respective facts and dimensions folders are also functionally grouped under headers (identifiers, cost, distance, flex fields, etc.) for ease of identification and usage.

Note: While performing ad-hoc queries or building customer-defined reports end users are warned to not use dimensions or columns across analysis folders as these may lead to query errors due to incompatibility.

GTI Dashboard Prompts

This section describes all of the out-of-the-box prompts shipped with Global Trade Intelligence.

Declaration Exports GTI Period Prompt

This prompt provides the ability to filter facts by the declaration type and time dimension with the filters laid out horizontally.

This file is located in the catalog in /Shared Folders/GTI Dashboard Prompts/Declaration Exports GTI Period Prompt

Prompt Column	Based on Dimension	Definition	Default Value
Declaration Type	"Declaration Dimensions"."GTM Declaration Type GID"	This prompted column displays the list of declaration type IDs.	<All column values>
Year	"Declaration Export Date Period Dimensions"."Export Year"	This prompted column displays the list of years; that is period dimension records grouped at the level of year.	<Current Year>
Week	"Declaration Export Date Period Dimensions"."Export Week"	This prompted column displays the list of weeks; that is period dimension records grouped at the level of week.	<Current Week>
Month	"Declaration Export Date Period Dimensions"."Export Month"	This prompted column displays the list of months; that is period dimension records grouped at the level of month.	<Current Month>
Quarter	"Declaration Export Date Period Dimensions"."Export Quarter"	This prompted column displays the list of quarters; that is period dimension records grouped at the level of quarter.	<Current Quarter>

Declaration Imports GTI Period Prompt

This prompt provides the ability to filter facts by the declaration type and time dimension with the filters laid out horizontally.

This file is located in the catalog in /Shared Folders/GTI Dashboard Prompts/Declaration Imports GTI Period Prompt

Prompt Column	Based on Dimension	Definition	Default Value
Declaration Type	"Declaration Dimensions"."GTM Declaration Type GID"	This prompted column displays the list of declaration type IDs.	<All column values>
Year	"Declaration Import Date Period Dimensions"."Import Year"	This prompted column displays the list of years; that is period dimension records grouped at the level of year.	<Current Year>
Week	"Declaration Import Date Period Dimensions"."Import Week"	This prompted column displays the list of weeks; that is period dimension records grouped at the level of week.	<Current Week>
Month	"Declaration Import Date Period Dimensions"."Import Month"	This prompted column displays the list of months; that is period dimension records grouped at the level of month.	<Current Month>
Quarter	"Declaration Import Date Period Dimensions"."Import Quarter"	This prompted column displays the list of quarters; that is period dimension records grouped at the level of quarter.	<Current Quarter>

Export_GTI Period Prompt

This prompt provides the ability to filter facts by the time dimension with the filters laid out horizontally.

This file is located in the catalogin /Shared Folders/GTI Dashboard Prompts/Export_GTI Period Prompt

Prompt Column	Based on Dimension	Definition	Default Value
Year	"Trade Transaction Line Export Date Period Dimensions"."Export Year"	This prompted column displays the list of years; that is period dimension records grouped at the level of year.	<Current Year>
Week	"Trade Transaction Line Export Date Period Dimensions"."Export Week"	This prompted column displays the list of weeks; that is period dimension records grouped at the level of week.	<Current Week>
Month	"Trade Transaction Line Export Date Period Dimensions"."Export Month"	This prompted column displays the list of months; that is period dimension records grouped at the level of month.	<Current Month>
Quarter	"Trade Transaction Line Export Date Period Dimensions"."Export Quarter"	This prompted column displays the list of quarters; that is period dimension records grouped at the level of quarter.	<Current Quarter>

GTI Period Prompt

This prompt provides the ability to filter facts by the time dimension with the filters laid out horizontally.

This file is located in the catalog in /Shared Folders/GTI Dashboard Prompts/GTI Period Prompt

Prompt Column	Based on Dimension	Definition	Default Value
Year	"- Trade Transaction Line Export Date Period Dimensions"."Export Year"	This prompted column displays the list of years; that is period dimension records grouped at the level of year.	<Current Year>
Week	"- Trade Transaction Line Export Date Period Dimensions"."Export Week"	This prompted column displays the list of weeks; that is period dimension records grouped at the level of week.	<Current Week>
Month	"- Trade Transaction Line Export Date Period Dimensions"."Export Month"	This prompted column displays the list of months; that is period dimension records grouped at the level of month.	<Current Month>
Quarter	"- Trade Transaction Line Export Date Period Dimensions"."Export Quarter"	This prompted column displays the list of quarters; that is period dimension records grouped at the level of quarter.	<Current Quarter>

Import_GTI Period Prompt

This prompt provides the ability to filter facts by the time dimension with the filters laid out horizontally.

This file is located in the catalog in /Shared Folders/GTI Dashboard Prompts/Import_GTI Period Prompt

Prompt Column	Based on Dimension	Definition	Default Value
Year	"Trade Transaction Import Date Period Dimensions"."Import Year"	This prompted column displays the list of years; that is period dimension records grouped at the level of year.	<Current Year>
Week	"Trade Transaction Import Date Period Dimensions"."Import Week"	This prompted column displays the list of weeks; that is period dimension records grouped at the level of week.	<Current Week>
Month	"Trade Transaction Import Date Period Dimensions"."Import Month"	This prompted column displays the list of months; that is period dimension records grouped at the level of month.	<Current Month>
Quarter	"Trade Transaction Import Date Period Dimensions"."Import Quarter"	This prompted column displays the list of quarters; that is period dimension records grouped at the level of quarter.	<Current Quarter>

Transaction - Order - GTI Period Prompt

This prompt provides the ability to filter facts by the time dimension with the filters laid out horizontally.

This file is located in the catalog in /Shared Folders/GTI Dashboard Prompts/Transaction - Order - Period Prompt

Prompt Column	Based on Dimension	Definition	Default Value
Year	"Trade Transaction Line Order Date Period Dimensions"."Order Year"	This prompted column displays the list of years; that is order date dimension records grouped at the level of year.	<Current Year>
Week	"Trade Transaction Line Order Date Period Dimensions"."Order Week"	This prompted column displays the list of weeks; that is order date dimension records grouped at the level of week.	<Current Week>
Month	"Trade Transaction Line Order Date Period Dimensions"."Order Month"	This prompted column displays the list of months; that is order date dimension records grouped at the level of month.	<Current Month>
Quarter	"Trade Transaction Line Order Date Period Dimensions"."Order Quarter"	This prompted column displays the list of quarters; that is order date dimension records grouped at the level of quarter.	<Current Quarter>

GTI Dashboard Reports

This is the default Global Trade Intelligence (GTI) dashboard (accessible to typical Oracle Transportation Management and Global Trade Management users) and contains reports covering the key business areas under respective tabs. This dashboard is available as a preferred dashboard in the OTM/GTM user preferences.

This main GTI Dashboard report is located in the catalog in /shared/GTI Reports/_portal/GTI Dashboard

The GTI dashboard has the following tabs:

Detailed Reports

The following section explains some of the details found across tabs in the GTI dashboard.

Export_GTI Transaction Line Count by License Code Report

This report shows the distribution of the transaction line count by the assigned license codes. This report is located in the catalog in /Shared Folders/GTI Reports/GTI Dashboard Reports/Export_GTI Transaction count by License Code

Import_GTI Declared Value by Transport Mode Report

This report shows the distribution of the declared value of transactions by transport mode. This report is located in the catalog in /Shared Folders/GTI Reports/GTI Dashboard Reports/Import_GTI Declared Value by Transport Mode.

3. Business Intelligence Server

Variables

Global Trade Management Subject Area

GTI Dashboard Prompts

Declaration Exports GTI Period Prompt

Declaration Imports GTI Period Prompt

Export_GTI Period Prompt

GTI Period Prompt

Import_GTI Period Prompt

Transaction - Order - GTI Period Prompt

GTI Dashboard Reports

Detailed Reports

Export_GTI Transaction Line Count by License Code Report

Import_GTI Declared Value by Transport Mode Report

Related Topics