Import the BAR file in an existing Oracle Business Intelligence Enterprise Edition instance

Before importing the BAR File, make sure:

• Oracle Business Intelligence Enterprise Edition 12.2.4 is installed

• The Administrator Console is up and running

  (validate it from http://machinename.port/console)

• The Oracle Enterprise Manager (Oracle Fusion Middleware Control) is up and running

  (validate it from http://machinename.port/em)

To import the BAR File:

1. Copy the BAR file from <AI HOME>OBIEE\BAR File\ssi.bar to a local folder on the machine where the Oracle Business Intelligence Enterprise Edition is installed.

   For example, copy the file at C:\AIOBIEE.

2. Login to the Oracle Enterprise Manager with the Oracle WebLogic Server credentials.

3. Click Target Navigation.

   

   The Target Navigation drop-down menu appears.

4. Go to Business Intelligence > biinstance.

   The Business Intelligence Instance screen appears.

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

   A confirmation dialog box appears.

6. Click Yes.

   All the running processes are stopped.

7. Go to the command prompt, and start the WebLogic Scripting Tool (using wlst.cmd on Windows, and wlst.sh on Unix/Linux) from the following path:

   OracleBI Home\Middleware\oracle_common\common\bin

8. To know the BI Service Instance key, type the following command, and press Enter.

   > listBIServiceInstances(domainHome)

   where, Domain Home is the directory of the Oracle Business Intelligence Install domain, the default path is:

   obiee_home/user_projects/domains/bi

   The Key appears at the end of the command.

   For example, ssi appears as the Key.

9. Exit WLST using the exit ()command.

10. To import the BAR file:

    1. Go to the Domain Home path:

       obiee_home/user_projects/domains/bi/bitools/bin

    2. Execute the following command:

       importarchive.cmd Oracle Business Intelligence Service Instance key <complete path of bar file to import>

       For example, importarchive.cmd ssi C:\ai823\ssi.bar

11. Go to Oracle Enterprise Manager, from the Availability tab, select Processes, and click Start All.

    A confirmation dialog box appears.

12. Click Yes.

    The BAR file imports the RPD, Catalog and the Security model.

To check if the BAR File has imported RPD, Catalog, and the Security Model:

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 default application roles:

   • AI Admin Role
   • AI Author Role
   • AI Consumer Role

   For a list of privileges assigned to these roles, refer to Oracle Business Intelligence Enterprise Edition Default Application Roles.

2. To modify the Connection Pool Settings:

   1. From the following path, right click the admintool.cmd file, and click Run as Administrator.

      obiee_home\user_projects\domains\bi\bitools\bin

      The Oracle Business Intelligence Admin Tool opens.

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

      Note:

      To open the RPD in online mode, you must set the Open Database Connectivity (ODBC). Refer to the Create ODBC Connection for OBIEE Administration Tool for Oracle Argus Insight.

      If Oracle Business Intelligence Enterprise Edition is installed on the Unix or Linux machine, set up the Oracle Business Intelligence Developer Client Tool on any Windows machine to access the Oracle Business Intelligence Administration Tool.

   3. Click the Connection Pool, and modify the Data source name, User name, and Password.

      Modify both the connection pools: AI80OBIEE_CP and AI80OBIEE_CP_InitBlocks.

3. Check-in the changes, and save the RPD.

   Ignore the warning messages that appear during the consistency check.

4. Create Oracle Business Intelligence Enterprise Edition Groups and Users. (See Create Users and Groups in Oracle Business Intelligence Enterprise Edition)

5. 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)

6. To view and administer privileges for the Oracle Business Intelligence components, login to Oracle Business Intelligence Enterprise Edition Analytics with Oracle WebLogic Server user credentials.

   Go to Administration > Security > Manage Privileges.

   For a list of privileges assigned to these roles, refer to Oracle Business Intelligence Enterprise Edition Default Application Roles.

7. Go to Administration > Maintenance and Troubleshooting, and click Reload Files and Metadata.

8. To use the AI Aggregate Analysis Subject area and Dashboard, login with a valid user credentials.