6.4 Integrating Oracle Business Intelligence Enterprise Editions (OBIEE) for Visualizations

You can create Oracle LSH Business Areas of type Oracle Business Intelligence Enterprise Edition to make data available to visualizations in OBIEE Answers. Definers can install the Administrator's Tool on their PC to develop more complex OBIEE Repository (.rpd) files to support more complex data visualizations. Users can then launch the Oracle Business Intelligence Dashboard through Oracle LSH or through a URL to see data visualizations.

Note:

Additional configuration is required. See the chapter on Oracle Business Intelligence visualizations in the Oracle Life Sciences Data Hub System Administrator's Guide.

Oracle LSH supports OBIEE 12.2.1.4 for visualizations. You must install the Distributed Processing (DP) Server on each machine where the Oracle BI server is installed.

• Install Oracle Business Intelligence Enterprise Edition 12.2.1.4 for Visualizations
  

6.4.1 Install Oracle Business Intelligence Enterprise Edition 12.2.1.4 for Visualizations

Install Oracle Business Intelligence Enterprise Edition to support visualizations as described in the following topics:

• Install Oracle Business Intelligence Enterprise Edition
  
• Disable Oracle Business Intelligence Enterprise Edition 12c Enterprise Manager SSO authentication
  
• Start the WebLogic Server
  
• Install the Oracle LSH DP Server
  
• Deploy Repository File
  
• Set Up Oracle Business Intelligence Enterprise Edition Visualizations
  

6.4.1.1 Install Oracle Business Intelligence Enterprise Edition

Install Oracle Business Intelligence Enterprise Edition 12.2.1.4 using Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence 12c Release 12.2.1.3 (E83388-01).

Note:

As noted in Oracle Fusion Middleware Installation Guide for Oracle Business Intelligence 12c Release 12.2.1.3, you need to install Oracle Fusion Middleware Repository Creation Utility 12c (12.2.1.3) before installing Oracle Business Intelligence Enterprise Edition 12c.

6.4.1.2 Disable Oracle Business Intelligence Enterprise Edition 12c Enterprise Manager SSO authentication

With Oracle Business Intelligence Enterprise Edition 12c, SSO authentication is enabled by default. For Oracle LSH users to access Analytics, disable the SSO authentication as described in the following procedure.

1. Log in to Oracle Business Intelligence Enterprise Edition 12c Enterprise Manager using as a WebLogic user.
2. From the Target navigation menu on left side of the screen, click biinstance under the Business intelligence folder.
3. Click the Security tab of Business Intelligence instance. Then click Lock & Edit from the Active Edit Session menu on the right side of the screen as shown:
   
4. Disable SSO by clearing the Enable SSO checkbox as shown. Then click Activate Changes from the Active Edit Session drop-down menu to apply the changes in Business Intelligence server.
   
5. Restart the WebLogic server to activate the changes as described in Start the WebLogic Server.

6.4.1.3 Start the WebLogic Server

If the URL for either Oracle Enterprise Manager or the WebLogic Administration Console is not working, the WebLogic Server may be down. To start it:

1. On the Business Intelligence server computer, traverse to <bi_home>\user_projects\domains\bi\bitools\bin directory.
2. Do one of the following:
   • To start the WebLogic server and Business Intelligence server, execute the start.cmd script.
   • To stop the WebLogic server and Business Intelligence server, execute the stop.cmd script. If you need to restart it, execute the start.cmd once the stop command completes successfully.

6.4.1.4 Install the Oracle LSH DP Server

You must install the Oracle LSH DP Server on the same machine; see Set Up the Distributed Processing Server.

• Copy and Edit Execution Command Scripts
  

6.4.1.4.1 Copy and Edit Execution Command Scripts

The obieedeploy.cmd and obieeinstall.cmd command script files should be modified for Oracle Business Intelligence Enterprise Edition 12c integration. The templates for these command scripts are available under $cdr/admin/template. Copy the Oracle LSH versions of obieedeploy.cmd and obieeinstall.cmd from $cdr/admin/templates to the Oracle LSH Distributed Processing Server location and referred to in the Execution Command under the Oracle Business Intelligence Enterprise Edition Install and Deploy service configured in Oracle LSH under the Oracle Business Intelligence Enterprise Edition Service Location.

Edit obieeinstall.cmd by configuring the following environment variables based on their values applicable for the local Oracle Business Intelligence Enterprise Edition environment.

• set PATH=%PATH%;C:\bi_home\bi\bifoundation\server\bin
• set ORACLE_BI_APPLICATION=coreapplication
• set ORACLE_BI_INSTANCE=C:\bi_home
• set COMPONENT_NAME=coreapplication_obis1
• set COMPONENT_TYPE=OracleServerComponent
• set ORACLE_INSTANCE=C:\bi_home
• set DOMAIN_HOME=C:\bi_home\user_projects\domains\bi

Edit obieedeploy.cmd by setting the RPD_DIR environment variable that indicates the Local Folder path where the Oracle LSH RPD will be copied during the Oracle Business Intelligence Enterprise Edition BA install from Oracle LSH. Similar to Oracle Business Intelligence Enterprise Edition 11g, in Oracle Business Intelligence Enterprise Edition 12c integration, this folder should point to any local folder path on the Business Intelligence server machine’s file system.

• set RPD_DIR=C:\RPD

6.4.1.5 Deploy Repository File

In Oracle LSH 3.0 (similar to Oracle Business Intelligence Enterprise Edition 11g), the RPD corresponding to the Oracle Business Intelligence Enterprise Edition BA is just copied on to a local folder on the Oracle Business Intelligence server machine. The RPD folder path is defined in the obieedeploy.cmd. The RPD copied in the RPD folder is required to be deployed manually. Unlike Oracle Business Intelligence Enterprise Edition 11g, the Business Intelligence server services need not be restarted manually through Oracle Enterprise Manager. In Oracle Business Intelligence Enterprise Edition 12c, RPD need to be uploaded through command line tool.

1. Run this command to upload the Oracle LSH RPD to the Oracle Business Intelligence Enterprise Edition 12c Business Intelligence server:
   %ORACLE_BI_INSTANCE%\user_projects\domains\bi\bitools\bin\datamodel.cmd uploadrpd -I <RPD filename> -W <RPD_Password> -SI <Service Instance> -U <Weblogic User> -P <Weblogic User Password>

   For example:

   datamodel.cmd uploadrpd -I C:\LSH_DP_SERVER\RPD\dmw30ut12c_win2016.rpd -W Password1 -SI ssi -U weblogic -P Password2
2. After you upload the RPD file to the Oracle Business Intelligence server, log in in to the Business Intelligence server Analytics page as a WebLogic user.
3. Click Administration from the right side of the screen. In Administration page, click Reload Files and Metadata to refresh the uploaded RPD file in the Oracle Business Intelligence server for further analytics use.
   

6.4.1.6 Set Up Oracle Business Intelligence Enterprise Edition Visualizations

See Chapter 11, "Setting Up Oracle Business Intelligence Visualizations" in the Oracle Life Sciences Data Hub System Administrator's Guide, for instructions.