Create a Dataset from Oracle Enterprise Performance Management (Oracle EPM)

Connect to an Oracle Enterprise Performance Management (Oracle EPM) application and visualize the data in a workbook. Data is accessed as a live query.

  1. In the homepage, click Create, then Connection, and select Oracle EPM Cloud.
  2. In the Create Connection dialog, enter connection details for your Cloud EPM Platform application.
    • In Authentication, select Use the active user's credentials.
  3. From the home page, click Create, then Dataset.
  4. At the Create Dataset dialog, select the Oracle EPM connection that you created in Step 2.
  5. In the Add Dataset dialog, select the cube to visualize, then click Add.

  6. Click Create Workbook, then add the data elements to the design canvas.
    Tip: Use filters to precisely locate the data in your cubes.