Check if the BAR file has imported RPD, Catalog, and the Security Mode

  1. To verify the Roles and Policies imported by BAR file in the Oracle Enterprise Manager, go to Business Intelligence Instance > Security > Application Roles and Application Policies.
    The following roles are imported as deafult application roles:
    • PVAdminRole
    • PVASafetyRole
    • PVASafetyConsumersRole
  2. To modify the Connection Pool Settings:
    1. From the following path, right click the admintool.cmd file, and click Run as Administrator

      <MiddlewareHome>\user_projects\domains\bi\bitools\bin

      The Oracle Analytics Tool opens.

      Note:

      If Oracle Analytics Server is installed on Unix or Linux machine, then you must setup the Oracle Analytics Developer Client tool on any windows machine to access Oracle Analytics Administration Tool.

      See Create ODBC Connection for Oracle Analytics Server Administration Tool.

    2. To open the RPD, select the online mode, and enter WebLogic user credentials.

      Note:

      You must set the Open Database Connectivity (ODBC).

      To open the RPD in the online mode on Unix or Linux, set the ODBC on a Windows machine where Oracle Analytics Server client is installed, and open the RPD.

    3. Click the Connection Pool, and modify the Data Source name, User name, and Password.
      Modify both the following connection pools:
      • Under OPVA_DWH database:
        • OPVA_CP:
          • Data Source Name--Oracle Argus Analytics database TNS Name
          • User name--Oracle Argus Analytics DWH RPD schema <AN_DWH_RPD>
          • Pasword--Password for Oracle Argus Analytics DWH RPD schema
        • OPVA_CP_InitBlocks:
          • Data Source Name--Oracle Argus Analytics database TNS Name
          • User name--Oracle Argus Analytics DWH RPD schema <AN_DWH_RPD>
          • Password--Password for Oracle Argus Analytics DWH RPD schema
      • Under OPVA_SRC database:
        • OPVA_CP:
          • Data Source Name--Oracle Argus Safety database TNS Name
          • User name--Oracle Argus Analytics SRC RPD schema <AN_SRC_RPD>
          • Password--Password for Oracle Argus Analytics SRC RPD schema
  3. Check-in the changes, and save the RPD
    Ignore the warning message that appear during the consistency check.
  4. To view and administer privileges for the Oracle Analytics components, login to Oracle Analytics Server Analytics (http://oasset.com:port/analytics) with WebLogic user credentials.
  5. Go to Security > Administration > Manage Privileges.
    For a list of privileges assigned to the Oracle Analytics Application roles, refer to Oracle Analytics Server Default Application Roles.
  6. Go to Catalog, and set the folder level permissions for the Oracle Analytics Server Groups. (See Oracle Analytics Server Catalog Folder-level Permissions)
  7. Create Oracle Analytics Server Groups and Users. (See Create Users and Groups in Oracle Analytics Server)