Build and Upload a Semantic Model for Oracle EPM Data Using Model Administration Tool

Build a semantic model on Cloud EPM Platform, then upload it to Oracle Analytics Cloud Enterprise Edition.

  1. In your local environment, start Model Administration Tool, and create a semantic model.
  2. Import the Planning and Budgeting metadata:
    1. From the File menu, select Import Metadata to start the import wizard.
    2. In the Select Data Source page, select Hyperion ADM from the Connection Type list.
    3. In the Select Metadata Objects page, enter connection details.

      For Connection Type, select Hyperion ADM.

      For Provider Type, select Hyperion Planning.

      For URL, specify the connection URL in the format:

      adm:thin:com.hyperion.ap.hsp.HspAdmDriver:<Server>%3A<Port>:<Application>

      Note: Specify the URL-encoded value %3A instead of a colon (:) to separate the host and port number.

      The connection URL is different on Oracle Cloud Infrastructure (Gen 1) and Oracle Cloud Infrastructure (Gen 2).

      • If your Planning and Budgeting application is deployed on Oracle Cloud Infrastructure (Gen 1), specify the connection URL as:

        adm:thin:com.hyperion.ap.hsp.HspAdmDriver:machine12345.oraclecloud.com%3A443:Vision?locale=en_US;tenantName=localhost;hubProtocol=https;

      • If your Planning and Budgeting application is deployed on Oracle Cloud Infrastructure (Gen 2), specify the connection URL as:

        adm:thin:com.hyperion.ap.hsp.HspAdmDriver:machine12345.oraclecloud.com%3A443:Vision;locale=en_US;tenantName=localhost;hubProtocol=https;

      For User Name and Password, specify the name and password of a user with administration privileges.

    4. When the import is complete, review the metadata in the Physical Layer.
    5. Make sure that you've selected the ANCESTOR_DIM_PROPERTY_SUPPORTED database feature.
  3. Complete your semantic model:
    1. Cut and paste tables in the Physical layer to the Business Model and Mapping layer and to the Presentation layer.
    2. Verify the semantic model and save it as an .rpd file.
  4. In the Physical layer, edit the Connection Pool for this data source, specify a URL using the URL that you used on the Select Metadata Objects page in step 1, and select Shared logon.
  5. Save the semantic model, and ignore the warning that the database features don't match the defaults.
  6. Upload the semantic model to Oracle Analytics Cloud. From the File menu, click Cloud, then click Upload, and enter connection information for your Oracle Analytics Cloud instance.
Users can analyze data and build dashboards using the new semantic model.