Add Oracle EPM Cloud Cube Tables to the Physical Layer

From the Oracle EPM Cloud connection, you can drag and drop cube tables to add them to the semantic model's physical layer.

You need to create one database in the physical layer for each cube or set of cubes.

Dragging and dropping a cube table from the data source connection to the physical database populates some of the database's features, the query features, and connection pools. You can adjust these settings as needed. You can add query limits for application roles to the database.

See About Connecting to an Oracle EPM Cloud Data Source.

1. On your home page, click Navigator and then click Semantic Models.
2. In the Semantic Models page, click a semantic model to open it.
3. Click Physical Layer .
4. In the Physical Layer pane click Create and then click Create Database.
5. In Create Database, go to Name and type a name. In the Database Type field select Oracle EPM Cloud. Click OK.
   The new database's Tables tab is displayed.
6. In the Tables tab, click Connections and in the connections pane, expand the Oracle EPM Cloud connection and browse or search for the cube table to add to the physical database.
7. Drag the cube table to the physical database and drop it into the Tables list.
8. Click the Connection Pools tab and verify that your database and connection pool settings are correct.
9. Click the Tables tab to inspect and confirm the imported physical columns and hierarchical levels.
10. Click Save.