Oracle Cloud Infrastructure Documentation

Configure Oracle Analytics for Applications Data

As the cloud account administrator with Functional Administrator or System Administrator application role, you specify the data load and reporting configuration details, and create pipeline activation plans that determine how the Oracle Fusion Application Services source data 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 be used for converting transactions to the global currency.

Typical Workflow to Configure Data

Follow these tasks as a guide to configure Oracle Analytics for Applications data.

Task Description More Information
Specify the global configuration details Set up the global configuration details for your data model file before running your data plans. Set up the Global Configuration
Specify the reporting configuration details Set up the reporting configuration details for your data model file before running your data plans. Set Up the Reporting Configuration of the Data Model File
Create a pipeline activation plan To start analyzing your Oracle Fusion Application Services data, create a plan to copy data to your data warehouse. Create a Pipeline Activation Plan
Edit a pipeline activation plan You can change any details of your pipeline activation plan prior to activating it. Edit a Pipeline Activation Plan
Activate a pipeline activation plan You must activate the plan to run and load data into your data warehouse. Activate a Pipeline Activation Plan
Deactivate a pipeline activation plan You can deactivate all the incremental set up and ETL plan jobs of a pipeline activation plan. Deactivate a Pipeline Activation Plan
Delete a pipeline activation plan You can delete a pipeline activation plan prior to activating it. Delete a Pipeline Activation Plan
Reload a plan for a functional area Perform this action to refresh the data for the selected functional area. Reload a Pipeline Activation Plan
Reset a pipeline activation plan You can reset an activated pipeline activation plan. Resetting the plan deletes all data from your data warehouse. Reset a Pipeline Activation Plan
View request history View the load request history by functional area, load type, and status apart from few other details. View Load Request History

About Pipeline Activation Plans

Pipeline Activation plans are load plans which load data specific to a functional area into the data warehouse.

These plans hold configuration parameters specific to a functional area. For example, General Ledger is a functional area under Finance.

You can't submit a pipeline activation plan in the following situations:
  • Load in progress: If an incremental load is in progress.
  • An impending load: If an incremental load is scheduled to run in the next hour.
  • Exceeded the number of daily refresh requests: If you've exceeded the maximum number of ad hoc data refresh requests for the day. In this case, you can submit a request the following day.

About Best Practices

Here's a list of the best practices to follow before running a pipeline activation plan.

  • Define the global and reporting configurations for the functional area accurately.
  • Schedule the data load to run during off-peak hours.
  • Run initial full warehouse loads during weekends and incremental loads during weeknights to ensure that users are not impacted.

About Global Configuration

The global configuration details apply to all functional areas.

The configuration details that apply at the functional area levels are currency, exchange rate type, and initial extraction date and time to schedule the incremental job to run.
  • Analytics Currency: Currency conversions are required because your business might have transactions captured in multiple currencies. To create meaningful enterprise-wide analyses, you must use a common currency. Oracle Analytics for Applications allows you to specify an analytics currency to store amounts in the data warehouse using this common currency. The load process checks the specified currency value and determines the corresponding exchange rate to convert the amounts to the analytics currency. For example, if your organization is a multinational enterprise that has its headquarters in the United States, you probably want to choose US dollars (USD) as the analytics currency.
  • Exchange Rate Type: Specify an exchange rate type that you want to use when converting the transaction amounts to the analytics currency. For example, you may set up Corporate as a standard exchange rate across your organization for a stable currency.

Set up the Global Configuration

Set up the global configuration details for your data model file before running your pipeline plans.

  1. Sign in to your service using the following steps:
    1. Sign in to the Oracle Cloud Infrastructure console.
    2. Open the Navigation menu. Under Solutions and Platform, click Analytics, and then click Analytics Apps for Fusion.

      You see the service instances page.

    3. On the service instances page, select the compartment and the instance where you need to do the configuration.
    4. Click the instance URL to access Oracle Analytics for Applications.
  2. In Oracle Analytics for Applications, open the Application Navigation menu, click Console, and then click Data Pipeline.
  3. On the Pipeline Activation page, click Global Configuration.
    You see the Global Configuration page.
  4. Specify the currency of the transaction data.
  5. Select an exchange rate type that you want to use when converting the transaction amounts to the global currency.
  6. Indicate the initial extract date from which to load the transaction data.
  7. Under Additional settings, specify the time when you want the incremental data load to happen daily.
  8. Click Save.

About Reporting Configuration

Set up the reporting configuration details to specify how data is presented on the KPI decks, visualizations, dashboards, and reports in Oracle Analytics for Applications.

Reporting configuration details contain these parameters that you need to set up:
  • Calendar: This parameter specifies the reporting calendar used in Oracle Analytics Cloud. All time options seen in the reporting layer are based off the calendar chosen in the configuration.
  • Chart of Accounts: This parameter controls the list of ledgers used for reporting and is used in tandem with the Calendar parameter.
  • Ledgers: This parameter restricts the ledgers in the reporting layer and in the security setup. The list of values for this parameter are the ledgers which share the same calendar and the chart of accounts selected in the previous two parameters. The ALL option selects all ledgers which share the calendar and the selected chart of accounts.
  • Ledger Sets: This optional parameter restricts the ledger sets in the reporting layer and in the security setup. The list of values for this parameter are the ledger sets which share the same calendar and the chart of accounts selected in the previous two parameters.

Set Up the Reporting Configuration of the Data Model File

Specify reporting configuration details for your data model file.

  1. Sign in to your service.
  2. In Oracle Analytics for Applications, open the Application Navigation menu, click Console, and then click Data Pipeline.
    You see the Pipeline Activation page.
  3. On the Pipeline Activation page, click Report Configuration.
    You see the Report Configuration page.
  4. On the Report Configuration page, click your service, for example Enterprise Resource Planning and under it Oracle Financial Analytics.
  5. Select a fiscal calendar to configure the reporting calendar to be used in Oracle Analytics Cloud.
  6. Select a chart of accounts to control the list of ledgers used for reporting.
  7. In Ledgers, select ALL to use all the available ledgers in the reporting layer and in the security setup.
  8. Optionally, in Ledgers Sets, select the ledgers sets that you want to use in decks and data visualizations.
  9. Click Save.

Create a Pipeline Activation Plan

To start analyzing your Oracle Fusion Application Services data, create a plan to copy data to your data warehouse.

Perform this task only after you have set up the global and reporting parameters.
  1. Sign in to your service.
  2. In Oracle Analytics for Applications, open the Application Navigation menu, click Console, and then click Data Pipeline.
    You see the Pipeline Activation page.
  3. On the Pipeline Activation page, click your service. For example, under Enterprise Resource Planning, click Oracle Financial Analytics.
  4. On the service page, for example, the Oracle Financial Analytics page, click Create.
  5. Select your application areas to transfer data to the warehouse, and then click Next.
  6. Review the parameters and click one of the options:
    • Cancel: To cancel the plan.
    • Save: To save the plan but not activate it.
    • Activate: To display the page for scheduling when to run the plan. Select Scheduled Execution Data to specify the date and time on which to run the plan. Select Run Immediately to create and run a job for the plan immediately.
Oracle Analytics for Applications extracts data only from the initial extract date that you specify. Any data added prior to the initial extract date won’t be part of this data activation plan. You see your pipeline activation plan listed on the Pipeline Activation page.

Edit a Pipeline Activation Plan

You can change any details of your pipeline activation plan prior to activating it.

  1. Sign in to your service.
  2. In Oracle Analytics for Applications, open the Application Navigation menu, click Console, and then click Data Pipeline.
    You see the Pipeline Activation page.
  3. On the Pipeline Activation page, click the Action menu for the pipeline activation plan that you want to edit, and click Edit.
  4. Make the changes, review the changes, and then click Save or Activate.

Activate a Pipeline Activation Plan

You must activate the plan to run it and load the data into your data warehouse.

  1. Sign in to your service.
  2. In Oracle Analytics for Applications, open the Application Navigation menu, click Console, and then click Data Pipeline.
    You see the Pipeline Activation page.
  3. On the Pipeline Activation page, click the Action menu for the saved pipeline activation plan that you want to activate, and click Edit.
  4. Review the plan details and click Activate.
    You see the page to schedule when to run the plan.
  5. Select Scheduled Execution Data to specify the date and time on which to run the plan. Select Run Immediately to create and run a job for the plan immediately. Click Finish.
Oracle Analytics for Applications runs the pipeline activation plan, loads data into your data warehouse, and displays your activation plan on the Pipeline Activation Plans page. Once data is successfully loaded, the system updates the plan status to Activation Completed.

Deactivate a Pipeline Activation Plan

You can deactivate all the incremental setup and jobs of a pipeline activation plan. Deactivating a plan ensures that future incremental jobs don't select the specific functional area when the plan runs.

  1. Sign in to your service.
  2. In Oracle Analytics for Applications, open the Application Navigation menu, click Console, and then click Data Pipeline.
    You see the Pipeline Activation page.
  3. On the Pipeline Activation page, click the Action menu for the active pipeline activation plan that you want to deactivate, and click Deactivate.
You see your activation plan on the Pipeline Activation Plans page with Deactivated status.

Delete a Pipeline Activation Plan

You can delete a pipeline activation plan prior to activating it.

Deleting a plan permanently removes it, so data refreshes of the warehouse won't occur.
  1. Sign in to your service.
  2. In Oracle Analytics for Applications, open the Application Navigation menu, click Console, and then click Data Pipeline.
    You see the Pipeline Activation page.
  3. On the Pipeline Activation Plans page, click the Action menu for the activation plan that you want to delete, and click Delete.

Reload a Pipeline Activation Plan

Reload an activated pipeline activation plan to refresh the data for the selected functional area.

Performing this action refreshes the data for the selected functional area. The next scheduled run may take additional time to complete.
Note

Executing an on-demand data refresh while working on the data may cause temporary inconsistencies.
  1. Sign in to your service.
  2. In Oracle Analytics for Applications, open the Application Navigation menu, click Console, and then click Data Pipeline.
    You see the Pipeline Activation page.
  3. On the Pipeline Activation page, click the Action menu for the pipeline activation plan whose data you want to refresh, and then click Refresh Data.
    The system executes an incremental load immediately. If you had reset a pipeline activation plan before refreshing data, then the system runs a full load immediately for that functional area.

Reset a Pipeline Activation Plan

When you reset a pipeline activation plan, you delete all data from your data warehouse and the deletion is irreversible.

  1. Sign in to your service.
  2. In Oracle Analytics for Applications, open the Application Navigation menu, click Console, and then click Data Pipeline.
    You see the Pipeline Activation page.
  3. On the Pipeline Activation page, click the Action menu for the pipeline activation plan that you want to reset, and click Reset.
You see your activation plan on the Pipeline Activation Plans page with Reset Completed status.

View Load Request History

You can view the load request history by functional area, load type, and status along with other details.

  1. Sign in to your service.
  2. In Oracle Analytics for Applications, open the Application Navigation menu, click Console, and then click Data Pipeline.
    You see the Pipeline Activation page.
  3. Click Application Navigation on the top left and then click Request History.
  4. On the Request History page, view the history of loads that have been performed.
    Note

    The request history doesn't display the incremental loads.

View Audit Log

You can view the modifications made to entities in the Pipeline Activation process such as Ledgers, Analytics Currency, and functional areas.

  1. Sign in to your service.
  2. In Oracle Analytics for Applications, open the Application Navigation menu, click Console, and then click Data Pipeline.
    You see the Pipeline Activation page.
  3. Click Application Navigation on the top left and then click Audit Log.
  4. On the Audit Log page, view the list of all the modifications.