Model Essbase Data Using Model Administration Tool

You can model data from Essbase cubes using Model Administration Tool.

Before you start, deploy Data Gateway with your Oracle Analytics instance and configure a Data Gateway agent to communicate with the remote Essbase deployment.
  1. In the Physical Layer, create a database:
    1. Right-click in the Physical Layer pane and select Create New Database.
    2. At the Database dialog, specify a name to identify your database within Oracle Analytics.
    3. Select the Database Type (for example, Essbase 11), then click OK.
  2. In the Physical Layer, create a connection pool:
    1. Right-click the new database, click Create New Object, then select Database Connection Pool.
    2. At the Connection Pool dialog, specify a name to identify the database pool within Oracle Analytics.
    3. In Essbase Server, specify the connection string for your Essbase server.
      For example, http://<IP address>:<port number>/essbase/agent.
    4. Select Use Data Gateway.
    5. Enter the User name and Password for the Essbase deployment.
    6. If prompted, re-enter the password for the Essbase deployment.
  3. In the Physical Layer, import the Essbase metadata:
    1. Right-click the Essbase connection and select Import Metadata.
    2. At the Select Data Source page, click Next.
    3. At the Select Metadata Objects page, expand the database in the Data source box, select the cube you want, then click Import selected.

      For a large cube, the import can take two to three minutes.

    4. When the import is complete, expand the database in the Repository View to display the imported Essbase cube.
    5. Click Finish.
  4. Using the physical layer that you've just created, create your business model and mapping layer, and your presentation layer.
  5. Click File, Cloud, then Publish.
  6. Create a dashboard or visualization workbook based on your Essbase cube.
    The new Essbase cube is now available as a subject area in Oracle Analytics.
    For example, in Oracle Analytics, create an analysis and in the Select Subject Area dialog you can access the new Essbase subject area. In Oracle Analytics, create a workbook and in the Add Dataset dialog, click Subject Areas to access the new Essbase subject area.