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 Business Intelligence Tool opens.

      Note:

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

      See Create ODBC Connection for Oracle Business Intelligence Enterprise Edition 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 Business Intelligence Enterprise Edition 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 Business Intelligence components, login to Oracle Business Intelligence Enterprise Edition Analytics (http://obieeset.com:port/analytics) with WebLogic user credentials.
  5. Go to Security > Administration > Manage Privileges.
    For a list of privileges assigned to the Oracle Business Intelligence Application roles, refer to Oracle Business Intelligence Enterprise Edition Default Application Roles.
  6. Go to Catalog, and set the folder level permissions for the Oracle Business Intelligence Enterprise Edition Groups. (See Oracle Business Intelligence Enterprise Edition Catalog Folder-level Permissions)
  7. Create Oracle Business Intelligence Enterprise Edition Groups and Users. (See Create Users and Groups in Oracle Business Intelligence Enterprise Edition)