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. Clean up initialization block information:
   1. Verify that initialization blocks point to the correct data source.
   2. Disable or delete unused initialization blocks that you don't need anymore.
   3. Remove any initialization blocks for authentication and authorization (set values for 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. Delete unused database connections that you don't need anymore.
6. To optimize query performance, verify that the database parameters DEFAULT_BULK_FETCH_ROW_COUNT and MAX_BULK_FETCH_BUFFER_SIZE are set correctly for Oracle Analytics Cloud.
   1. In the Physical Layer pane, select the database connection you want to verify, and open the Feature pane.
   2. Verify the following parameters are above the minimum recommended values for Oracle Analytics Cloud to avoid latency issues.

      • DEFAULT_BULK_FETCH_ROW_COUNT: 1000 (minimum recommended value)

        If less than the minimum recommended value, increase to 1000. If set to a higher value, you can leave as-is.

      • MAX_BULK_FETCH_BUFFER_SIZE : 3276800 (minimum recommended value)

        If less than the minimum recommended value, increase to 3276800. If set to a higher value, you can leave as-is.

      
      Description of the illustration ceal_database_odw_settings.jpg
   3. Repeat these steps for each database in the physical layer.
7. 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.

8. 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.