1. Connecting Oracle Analytics Cloud to Your Data
  2. Connecting Oracle Analytics Cloud to Your Data
  3. Connect to Data
  4. Connect to Oracle Fusion Cloud Enterprise Performance Management (EPM)

Connect to Oracle Fusion Cloud Enterprise Performance Management (EPM)

You can create a connection to Oracle Fusion Cloud Enterprise Performance Management (EPM) and use the connection to access data.

Before you start, make sure that your product is supported. See Which Oracle EPM Business Processes Does Oracle Analytics Support?.
  1. On the Home page, click Create and then click Connection.
  2. Click Oracle EPM Cloud and enter the connection details.
  3. For URL, enter the URL for the Oracle Fusion Cloud Enterprise Performance Management (EPM) data source.

    For EPM deployments on OCI Classic, enter the full URL in the format:

    https://epm-mySecurityDomain.epm.domain.mycloud.oracle.com/mySecurityDomain

    For example:

    https://example-idDomain.pbcs.dom1.oraclecloud.com/idDomain

    For EPM deployments on OCI Gen 2, enter the EPM URL, excluding the application context (epmcloud or Hyperion):

    https://epm-99999-plan.hap.fra.demoservices999.oraclepdemos.com/epmcloud

    For example:

    https://epm-99999-plan.hap.fra.demoservices999.oraclepdemos.com

  4. Under Authentication, click Use the active user’s credentials.
    Oracle Analytics doesn't prompt users to sign in to access the data. The same credentials they used to sign in to Oracle Analytics are also used to access this data source. Make sure that the Oracle Analytics user exists in Oracle Fusion Cloud Enterprise Performance Management (EPM).
  5. Save the details.
    You can now create datasets from the connection and visualize the data.
See Visualize Data From Oracle Enterprise Performance Management (Oracle EPM).

Which Oracle EPM Business Processes Does Oracle Analytics Support?

When you integrate Oracle Analytics with Oracle Enterprise Performance Management, make sure that you're connecting to one of the supported business processes:

Oracle Analytics supports:
  • Financial Consolidation and Close
  • FreeForm
  • Planning and Planning Modules
  • Profitability and Cost Management
  • Tax Reporting
Oracle Analytics doesn't support:
  • Account Reconciliation
  • Enterprise Data Management Cloud
  • Narrative Reporting