Axis RightFax 8.5 Installationsanleitung PDF herunterladen (Seite 54)

9-2

 GTI_DEFAULT: This VPD profile is applicable for all Oracle Global Trade Intelligence users.

This includes all the external predicates available in the existing DEFAULT and FTI_DEFAULT

Oracle Transportation Management VPD profiles and the new external predicates specific to

the Oracle Global Trade Intelligence solution’s Historical Database tables.

As a result, it is mandatory that you update the user role for all your existing Oracle Fusion

Transportation Intelligence users to include the GTI_DEFAULT profiles, as applicable. Performing this

manual step is mandatory to ensure the proper operational behavior of the Oracle Global Trade

Intelligence application.

If you are using a customized VPD profile in Oracle Transportation Management, alternatively you

must manually include your additional external predicates over the GTI_DEFAULT VPD profile as

applicable.

Populating the AD_TIME Table

The AD_TIME table is not populated by the Global Trade Intelligence installation. If you want to use

fiscal time as a dimension, you must populate the AD_TIME table as follows:

1. Populate the following columns in the AD_TIME table in the Oracle Transportation Management

database schema. These columns correlate standard calendar dates to the fiscal dates.

a. FISCAL_YEAR VARCHAR2(50)

b. FISCAL_QUARTER_ID VARCHAR2(50)

c. FISCAL_MONTH_ID VARCHAR2(50)

d. FISCAL_WEEK_ID VARCHAR2(50)

e. FISCAL_DAY VARCHAR2(50)

2. Run the ETL.

Configuring Global Trade Intelligence with OAM (SSO)

Refer to the Configuring FTI/GTI with OAM (SSO) in the OAM Integration Guide for details on setting

up single-sign on for Global Trade Intelligence with OAM.

Configuring Oracle Data Integrator (ODI)

ETL Performance Tuning

When you have very large OLTP/ROD source databases, such as ETL source, there is a chance of the

ETL running slowly. You can complete the steps listed in ETL Performance Tuning to improve ETL

performance.

Note: These steps may slow down inserts/updates of data, so only complete this section

when it is absolute necessary to optimize ETL.

1 2 ... 49 50 51 52 53 54 55 56 57 58 59 ... 105 106

Keine Kommentare

Axis RightFax 8.5 Installationsanleitung Seite 54