25 Create a New Semantic Model Using Model Model Administration Tool

Administrators can use Model Administration Tool to create semantic models for data sources that Semantic Modeler doesn't support, for example Essbasse and EPM.

Note:

Before you create a model, check to see if Semantic Modeler supports the data source. If the data source is supported, use Semantic Modeler rather than Model Administration Tool to create and build the model. See Data Sources Supported for Semantic Models.

Topics

• About Creating Semantic Models with Model Administration Tool

• Typical Workflow to Model Data Using Model Administration Tool

• Create a New Semantic Model File in Model Administration Tool

About Creating Semantic Models with Model Administration Tool

Data modelers can use the Model Administration Tool to create semantic models for any data source that Semantic Modeler doesn't support. Administrators can upload completed semantic model files to Oracle Analytics Cloud.

Data Sources

You can build semantic models for several data sources that Semantic Modeler doesn't support. For example:

• Oracle Analytic Views
• Oracle Essbase
• Oracle EPM Cloud
• Oracle Hyperion Planning
• MySQL Heatwave
• PostgreSQL
• Vertica

For a complete up-to-date list, see Supported Data Sources.

Prerequisites

• One or more of the data sources listed.

• A Windows 64–bit machine on which to download Oracle Analytics Client Tools and run Model Administration Tool. See Download and Install Oracle Analytics Client Tools.

  Note:

  Oracle publishes new Oracle Analytics Client Tools with each Oracle Analytics Cloud update. After Oracle updates your Oracle Analytics Cloud environment, you must always download and start using the latest Oracle Analytics Client Tools.

• Valid user credentials to upload a completed semantic model file to Oracle Analytics Cloud. A user in the Oracle Cloud identity management system associated with Oracle Analytics Cloud who has administrator permissions in Oracle Analytics Cloud (that is, a user with the BIServiceAdministrator application role).

  Your Oracle Analytics Cloud uses one of these Oracle Cloud identity management systems:

  • Oracle Identity Cloud Service (IDCS): If your Oracle Analytics Cloud federates with Oracle Identity Cloud Service you must connect with Oracle Identity Cloud Service user credentials.
  • Oracle Cloud Infrastructure Identity and Access Management (IAM) Identity Domains: If your Oracle Analytics Cloud uses an IAM identity domain for identity management, you must connect with identity domain user credentials.

  If you're not sure, ask your cloud service administrator. See About Setting Up Users and Groups.

  If Oracle Analytics Cloud uses an external identity provider such as Active Directory for Single Sign-on (SSO) and you try to connect with your SSO user credentials, you see the message "Connection failed 401: Unauthorized" when you try to connect.

• The required port is open to connect to and access Oracle Analytics Cloud. For HTTPS access, open port 443. For HTTP access, port 80. If you're not sure, check with your cloud service administrator.

Typical Workflow to Model Data Using Model Administration Tool

Here are the common tasks for modeling data with Model Administration Tool.

Task	Description	More Information
Understand when to use Model Administration Tool	Understand the data sources that you can model and any prerequisites.	About Creating Semantic Models with Model Administration Tool
Download Model Administration Tool	Download and install Model Administration Tool for Oracle Analytics in you local environment.	Download and Install Oracle Analytics Client Tools
Create a new semantic model file	Open Model Administration Tool, start a new model, and connect it to your data source.	Create a New Semantic Model File in Model Administration Tool
Build the model	Design and build your semantic model (or metadata repository) for Oracle Analytics Cloud. The design steps are the same as those for Oracle Analytics Server. Refer to the Oracle Analytics Server documentation for more information.	Introduction to Building Your Metadata Repository
Upload the semantic model	Use Model Administration Tool to upload your semantic model to the cloud.	Upload a Semantic Model to the Cloud

Create a New Semantic Model File in Model Administration Tool

To get started, you must open Model Administration Tool, create a new semantic model file, and set up a connection to your data source.

1. Open Model Administration Tool.
   Go to your Windows Start menu, click Oracle Analytics Client Tools, and then select Model Administration Tool.
2. Select File, then select New Repository.
3. Enter a name for your semantic model file.
4. In Import Metadata, select No.
5. Enter a password for the semantic model file.
6. Click Finish.
7. Connect to your data source.
   Follow the instructions for your data source:

   • MySQL Heatwave, Vertica: Connect to a Data Source Using a Data Connection
   • Oracle Analytics Views: Build a Semantic Model from Analytic Views in Oracle Autonomous Data Warehouse
   • Oracle Essbase, Oracle Hyperion Planning, Oracle EPM Cloud, PostgreSQL:

     Follow instructions in the Oracle Analytics Server documentation as the steps are the same.

     • Oracle Essbase: About Setting Up Essbase Data Sources
     • Oracle Hyperion Planning and Oracle EPM Cloud : About Setting Up Hyperion Financial Management Data Sources
     • PostgreSQL: Create a Database Object Manually in the Physical Layer

Now you can design and build your semantic model (or metadata repository) for Oracle Analytics Cloud. The design steps are the same as those for Oracle Analytics Server. Refer to the Oracle Analytics Server documentation for more information. See Introduction to Building Your Metadata Repository.