Your company has developed Oracle Fusion Territory Management and ask the administrator to
enable the dimensions in the territory definition by using data warehousing.
Select the correct-sequence of activities.
1. Populate the visibility settings in data warehouse by running ETL.
2. Identify the dimension members to be made visible for territory definition in Territory
management.
3. Synchronize the territory management stage environment with the data source.
4. Populate the data warehouse with dimension members and transactional data.
A.
2, 3, 1, 4
B.
4, 2, 1, 3
C.
2, 1, 4, 3
D.
3, 2, 1, 4
Explanation:
In the Data Warehouse option, the data warehouse Extract-Transform-Load (ETL)
logic extracts transaction and dimension data from Oracle Fusion Applications into the data
warehouse first(4). The data warehouse stores dimensions and metrics data. Metrics data is
based on transactioninformation. Territory Management contains only a subset of the dimensions
stored in data warehouse(2).
This figure shows the use of ETL to load data from Fusion Applications to the data warehouse,
and RPD to provide data to the cube and to Territory Management. ETL also loads the settings for
visible and invisible dimension members from Territory Management to the data warehouse(1).http://docs.oracle.com/cd/E25054_01/fusionapps.1111/e20373/graphics/mot_dterritory_warehouse_02_10104843.png
Oracle Fusion Applications Sales Implementation Guide, Data Warehouse Option
