23 Upload Semantic Model Files from Oracle Analytics Server

Administrators can upload semantic models built with Oracle Analytics Server to Oracle Analytics Cloud. After uploading a semantic model .rpd file to the cloud, content authors can then build data visualizations, dashboards, and analyses in the usual way.

Note:

If the semantic model you created in Oracle Analytics Server uses a data source that Semantic Modeler supports, then migrate your .rpd file to Semantic Modeler. See Data Sources Supported for Semantic Models.

Topics

• About Uploading Semantic Model Files from Oracle Analytics Server to the Cloud

• Get Your Semantic Model File Ready

• Upload Semantic Models from a .rpd File Using Console

About Uploading Semantic Model Files from Oracle Analytics Server to the Cloud

If you’ve already modeled your business data with Oracle Analytics Server, you don't need to start from scratch in Oracle Analytics Cloud. Ask an administrator to upload your semantic model file to Oracle Analytics Cloud and start exploring your data through visualizations, analyses, and dashboards.

Oracle Analytics Cloud lets you upload a semantic model .rpd file with:

• One or more semantic models

• Connections to one or more databases

You’ll need to validate your semantic model .rpd file and configure database connection details in your Oracle Analytics Server environment.

When your administrator uploads a semantic model .rpd file from Oracle Analytics Server, existing semantic models (if any) are deleted and replaced with content from the uploaded file. Semantic models uploaded from the file become available to content authors through the Subject Areas pane.

If model changes are required, administrators can use Model Administration Tool to edit and deploy their updates to Oracle Analytics Cloud. This tool is available with Oracle Analytics Client Tools. 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.

If you want to copy reports and dashboards built in Oracle Analytics Server to Oracle Analytics Cloud you can do that too. See Upload Content from a Catalog Archive in Visualizing Data and Building Reports in Oracle Analytics Cloud.

Get Your Semantic Model File Ready

Take some time to ready your semantic model .rpd file for the cloud.

1. Verify that you’re using Oracle Analytics Server.
2. Open your semantic model .rpd file and use Consistency Check Manager to run consistency checks.
3. Remove any initialization blocks that set the USER, ROLES or GROUP session variables.

   Oracle Analytics Cloud doesn’t support the variables :user and :password in data source connection credentials.

4. Verify that the database connection information in the semantic model is up-to-date.

   Review the connection pool settings from Oracle BI Administration Tool:

   • Data source name must contain the full connect string for the database where data is stored.

     You can’t specify a net service name here.

   • Call interface must be Oracle Call Interface (OCI).

   If your semantic model connects to multiple databases, ensure that the settings for each connection pool are correct.

5. Disable subject areas that you don't want to expose or that don't have a working connection.

   If connection information is missing, users see the message Fetch subject areas failed error when they view subject areas in Oracle Analytics Cloud.

6. Back up Oracle Analytics Cloud to a snapshot, including the current semantic model, in case you need to restore this version.

When the semantic model is ready, you can upload it to Oracle Analytics Cloud.

Upload Semantic Models from a .rpd File Using Console

Administrators can upload semantic models built with Oracle Analytics Server to Oracle Analytics Cloud. After migrating semantic models to the cloud, content authors can visualize data in the usual way.

When you upload semantic models from Oracle Analytics Server, you delete existing semantic model information in Oracle Analytics Cloud and replace it with content in the semantic model .rpd file. The semantic models you upload become available to content authors as subject areas.

Note:

You can also upload semantic model .rpd files to Oracle Analytics Cloud using Model Administration Tool (an Oracle Analytics Client Tools).

1. Verify the semantic model .rpd file and associated database connections.
2. In Oracle Analytics Cloud, click Console.
3. Select Snapshots.
4. Take a snapshot of the current semantic model in case you need to restore this version.
5. From the Page menu, click Replace Data Model.
6. Click Browse and select the semantic model .rpd file that you want to upload.
7. Enter the password for the file.
8. Click OK.
9. Go to the Home page, click Data, and then Datasets to see the semantic models that you uploaded, available as subject areas.
10. Optional: If the semantic model .rpd file includes permissions and data filters, create matching application roles in Oracle Analytics Cloud for the data security to work in the cloud.
    1. Create application roles with exactly the same names as those defined in Model Administration Tool.
    2. Assign users (and user roles) to the application roles as required.