Configure Oracle Analytics Server Repository and Web Catalog Manually

1. Copy the RPD, and Catalog files from <Argus Analytics Home>\report\opva.rpd and report\catalog\opva.zip folders to a machine where the Oracle Analytics Server is installed.
2. Open the RPD Admin tool in offline mode from the following path: <Middleware Home>\user_projects\domains\bi\bitools\bin\admintool.cmd
3. Open the opva.rpd file in offline mode. (The default password of the repository is opva1234
4. Click the Connection Pool, and modify the Data source name, User name, and Password.
   Modify the following connection pools:

   • Under OPVA_DWH database:
     • OPVA_CP:
       • Data Source Name—Argus Analytics database TNS Name
       • User name—Argus Analytics DWH RPD schema <AN_DWH_RPD>
       • Password—Password for Argus Analytics DWH RPD schema
     • OPVA_CP_InitBlocks:
       • Data Source Name—Argus Analytics database TNS Name
       • User name—Argus Analytics DWH RPD schema <AN_DWH_RPD>
       • Password—Password for Argus Analytics DWH RPD schema
   • Under OPVA_SRC database:
     • OPVA_CP:
       • Data Source Name—Argus Safety database TNS Name
       • User name—Argus Analytics SRC RPD schema <AN_SRC_RPD>
       • Password—Password for Argus Analytics SRC RPD schema
5. Save the changes, and close the RPD.
6. From the command prompt:
   1. Navigate to the <Middleware 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:\temp\opva.rpd -W opva1234 -U <username> -P <password> -SI ssi

      Note:

      In Linux, execute the data-model-cmd.sh command with same inputs.
7. Login to the Oracle Enterprise Manager with the WebLogic credentials.
8. Click Target Navigation.
   

   The Target Navigation drop-down menu appears.

9. Go to Business Intelligence > biinstance.

   The Oracle Analytics Instance screen appears.

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

    A confirmation dialog box appears.

11. Click Yes.

    All the running processes are stopped.

12. Extract the contents of Oracle Argus Analytics catalog opva.zip into a local folder, and navigate to \opva\root\shared folder.
    1. Copy the following folders and files:
       • current
       • current.atr
       • personal+user
       • personal+user.atr
       • retrospective
       • retrospective.atr
    2. Paste in <Oracle_Home>\user_projects\domains\bi\bidata\service_instances\ssi\metadata\content\catalog\root\shared folder.
13. Go to Oracle Enterprise Manager, from the Availability tab, select Processes, and click Start All.

    A confirmation dialog box appears.

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

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

19. Go to Catalog, and set the folder level permissions for the Oracle Analytics Server Groups. (See Oracle Analytics Server Catalog Folder-level Permissions)