Configure Oracle Analytics Server Repository and Web Catalog Manually

  1. Copy the RPD, and Catalog files from <AI HOME>OAS\RPD\ and <AI HOME>OAS\Catalog folders to a machine where the Oracle Analytics Server is installed.
  2. Open the RPD Admin tool in offline mode from the following path: oas_home\user_projects\domains\bi\bitools\bin\admintool.cmd

    The default Repository Password is insight123.

  3. Change the Connection Pool Settings.
  4. Save the changes, and close the RPD.
  5. From the command prompt:
    1. Navigate to the oas_home\user_projects\domains\bi\bitools\bin
    2. Run the following command:

      datamodel.cmd uploadrpd -I <RPDname> [-W <RPDpwd>] -U <cred_username> [-P <cred_password>] -SI <service_instance>

      For example, datamodel.cmd uploadrpd -I C:\AIOAS\RPD\ArgusInsight.rpd -W insight123 -U weblogic -P weblogic1 -SI ssi

  6. Login to the Oracle Enterprise Manager with the Oracle WebLogic Server credentials.
  7. Click Target Navigation.
    Target Navigation buton.

    The Target Navigation drop-down menu appears.

  8. Go to Business Intelligence > biinstance.

    The Business Intelligence Instance screen appears.

  9. From the Availability tab, select Processes, and click Stop All.

    A confirmation dialog box appears.

  10. Click Yes.

    All the running processes are stopped.

  11. Go to Catalog\argusinsight\root\shared folder:
    1. Copy argus+insight folder, and argus+insight.atr file.
    2. Paste in oas_home\user_projects\domains\bi\bidata\service_instances\ssi\metadata\content\catalog\root\shared folder.
  12. Go to Oracle Enterprise Manager, from the Availability tab, select Processes, and click Start All.

    A confirmation dialog box appears.

  13. Click Yes.
  14. Create User Groups and Users manually in Admin Console. (See Create Users and Groups in Oracle WebLogic Server.).
  15. Create Roles and policies manually in Oracle Enterprise Manager. (See Create Roles and Policies with Oracle Fusion Middleware Control.)
  16. To view and administer privileges for the Oracle Analytics components, login to Oracle Analytics Server Analytics with Oracle WebLogic Server user credentials.
  17. Go to Administration > Security > Manage Privileges.

    For a list of privileges assigned to these roles, refer to Oracle Analytics Server Default Application Roles.

  18. Go to Catalog, and set the folder level permissions for the Oracle Analytics Server Groups. (See Oracle Analytics Server Catalog Folder-level Permissions)
  19. Go to Administration > Maintenance and Troubleshooting, and click Reload Files and Metadata.
  20. To use the AI Aggregate Analysis Subject area and Dashboard, login with a valid user credentials.

Note:

All the WLST commands are case sensitive.

To start the WebLogic Scripting Tool on Unix or Linux, use wlst.sh command, rest all of the commands mentioned in the procedure remains same.

While executing the WLST commands on Windows server, you must use forward slash (/) to avoid any error messages. For example:

C:/AIOAS/instance/import/ssi.bar