Integrating Oracle Business Intelligence Enterprise Editions (OBIEE) for Visualizations

You can create Oracle LSH Business Areas of type Oracle Analytics Server 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 Analytics Server 12.2.1.4 for Visualizations
  

Install Oracle Analytics Server 12.2.1.4 for Visualizations

Install Oracle Analytics Server to support visualizations as described in the following topics:

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

Install Oracle Analytics Server

Install Oracle Analytics Server 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 Analytics Server 12c.

Disable Oracle Analytics Server 12c Enterprise Manager SSO authentication

With Oracle Analytics Server 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 Analytics Server 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.

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.

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
  

Copy and Edit Execution Command Scripts

The obieedeploy.cmd and obieeinstall.cmd command script files should be modified for Oracle Analytics Server 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 Analytics Server Install and Deploy service configured in Oracle LSH under the Oracle Analytics Server Service Location.

Edit obieeinstall.cmd by configuring the following environment variables based on their values applicable for the local Oracle Analytics Server 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 Analytics Server BA install from Oracle LSH. Similar to Oracle Analytics Server 11g, in Oracle Analytics Server 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

Deploy Repository File

In Oracle LSH 3.0 (similar to Oracle Analytics Server 11g), the RPD corresponding to the Oracle Analytics Server 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 Analytics Server 11g, the Business Intelligence server services need not be restarted manually through Oracle Enterprise Manager. In Oracle Analytics Server 12c, RPD need to be uploaded through command line tool.

1. Run this command to upload the Oracle LSH RPD to the Oracle Analytics Server 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.
   

Set Up Oracle Analytics Server Visualizations

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