3 Configure Oracle Fusion Analytics Warehouse Data

As the cloud account administrator with the Functional Administrator or System Administrator application role, you specify the data load and reporting configuration details, and create data pipelines for functional areas that determine how the source data from Oracle Applications Cloud is loaded and displayed in the data warehouse.

For example, you might specify the Initial Extract Date as January 1, 2019, specify the global currency as US Dollars (USD), and select the exchange rate to convert transactions to the global currency.

Note:

The times visible in the Console are in local time zone. However, Oracle Fusion Analytics Warehouse stores the values for the Warehouse Refresh Date Time and Scheduled Date in the Coordinated Universal Time (UTC) in the autonomous data warehouse.

Topics:

• Typical Workflow to Configure Data

• About Data Pipelines for Functional Areas

• About Pipeline Parameters
• Set Up the Pipeline Parameters
• About Global Parameters
• Set Up the Global Report Parameters
• About Report Parameters
• Set Up the Report Parameters for Enterprise Resource Planning
• Set Up the Report Parameters for Human Capital Management

• Create a Data Pipeline for a Functional Area

• Edit a Data Pipeline for a Functional Area

• Activate a Data Pipeline for a Functional Area

• Deactivate a Data Pipeline for a Functional Area

• Delete a Data Pipeline for a Functional Area

• Reload a Data Pipeline for a Functional Area

• Reset a Data Pipeline for a Functional Area

• Reset the Data Warehouse
• Reset the Cache
• View Load Request History
• View Audit Log
• About Augmenting Your Data