7.5 Deploying Analytic Reports and Threshold Analyzer

This section describes how to deploy Analytics on Oracle Business Intelligence Enterprise Edition (OAS 5.9) and integrate Analytic Reports and Threshold Analyzer in the OFSBD UI.

Installing Oracle Analytic Server (OAS) 5.9

To install the ORACLE ANALYTIC SERVER (OAS) 5.9, download the software from ORACLE ANALYTIC SERVER (OAS) 5.9 Server. After installation, get the Enterprise Manager URL, Username, Password, and ORACLE ANALYTIC SERVER (OAS) 5.9 installed directory from the system administrator.

Installing ORACLE ANALYTIC SERVER (OAS) 5.9 Windows Administration Client

Download and Install OAS client tool for 5.9.

Disabling the Cache Feature in Oracle Analytic Server (OAS) 5.9

Log in to the Enterprise Manager and perform the following steps:

  1. Click the Target navigation icon.
  2. Expand the Business Intelligence section and then click biinstance.
  3. Click the Configuration tab.
  4. Click the Lock icon and then click Lock & Edit to enable the Cache Enabled checkbox.
  5. Under the Performance tab, in the Enable Bi Server Cache section, de-select the Cache Enabled checkbox and make the required changes.
  6. Click the Lock icon and click Release Configuration to save the Cache Enabled changes.

    Figure 7-1 Disabling the Cache Feature in Oracle Analytic Server (OAS) 5.9

    This image shows the disabling the Cache Feature in Oracle Analytic Server (OAS) 5.9.

Change Default Repository Password

Copy FCCM81.rpd from $FIC_HOME/OBIEE/Repository to the Windows machine where the OAS Windows administration client is installed.

To change the default password for the repository, follow these steps:

  1. Open the Repository using the OAS Windows administration client from Windows machine.
  2. From the File menu, select Open and click Offline.
  3. Browse to the Repository on Windows machine.

    The Oracle BI Administration Tool - FCCM81.rpd windows is displayed.

  4. Enter default Repository password: FCCM$810.
  5. To change the default password, follow these steps:
    1. From the File menu, choose Change Password.
    2. Enter the new password and click OK.

Configuring ORACLE ANALYTIC SERVER (OAS) 5.9 Connection Pool

To configure the Connection Pool of the repository, follow these steps:

  1. Open the same Repository (as in the previous step) on the Windows machine.

    The Oracle BI Administration Tool - FCCM81.rpd window is displayed.

  2. Expand the FCCM folder in the Physical section.
  3. Double-click on the Connection Pool to open the Connection Pool Properties window.
  4. Enter the following in the Data Source Name text box of the Connection Pool Properties window after modifying
    <Database Server Host Name> and <Database Name> Data Source Name = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<Database Server HostName>)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED) (SERVICE_NAME=<Database Name>)))
  5. Enter the Atomic Schema user in the User name textbox.
  6. Enter the Atomic Schema user password in the Password textbox.
  7. Click OK.
  8. Expand the folder and test connection for any one table name (right click and then select View Data).
  9. Perform similar changes in the Connection Pools for all remaining folders in the Physical Layer by providing the following schema details for all Connection Pools:
    • KYC Analytics >Atomic Schema
    • UIC_73 > CaseMng connection pool ->Atomic SchemaUIC_73 > Security connectionpool->Atomic Schema
    • TA > Atomic Schema
    • CTRBI-> Atomic Schema
    • ORCL->Atomic Schema
    • FCCM > Atomic Schema
  10. From the File menu, click Save.

    The following message is displayed: Do you want to check global consistency?

  11. Click Yes.

    The following message is displayed: Consistency check did not find any errors, warning or best practices violations.

  12. Click OK.

Deploying OFS FCCM Report Analytics

To deploy Analytic Reports, follow these steps:

  1. Login to System Settings using the below URL:

    http://<oas server name>:<oas analytics port number>/analytics/systemsettings/ (for example: http://testserver:9502/analytics/systemsettings/)

  2. Search for Evaluate in the search box.
  3. Select Level 2 from the Evaluate Support Level drop-down.
  4. Search for HTML in the search box.
  5. Enable Allow HTML Content.
  6. Click Restart.
  7. Update the instanceconfig.xml file available in the <Oracle Analytic Server (OAS) 5.9_home>/user_ projects/domains/bi/config/fmwconfig/biconfig/OBIPS location as detailed here.
  8. Replace the following script:
    <Security>
This Configuration setting is managed by Oracle Enterprise Manager Fusion
Middleware Control-->
<ClientSessionExpireMinutes>210</ClientSessionExpireMinutes>
</Security>

    With the following:

    <Security>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion
Middleware Control-->
<ClientSessionExpireMinutes>210</ClientSessionExpireMinutes>
<InIFrameRenderingMode>allow</InIFrameRenderingMode>
</Security>
  9. Deploy BAR(CATALOG)
    1. Navigate to $FIC_HOME/OBIEE/catalog.
    2. Copy FCCM_ANALYTICS.bar to the working location of OAS server.
    3. Copy FCCM81.rpd into the working location of OAS server.
    4. Go to the <OAS 5.9 Home directory>/Oracle_Home/user_projects/domains/bi/bitools/bin path.
    5. Execute the command:
      ./importarchive.sh ssi <working location>/FCCM_ANALYTICS.bar encryptionpassword='<pwd>'

      Note:

      pwd is the same as RPD (Repository) password.
  10. Deploy FCCM81.rpd.
    1. Navigate to the working directory and execute the following script:
      <Oracle Analytic Server (OAS) 5.9_home>/user_projects/domains/bi/ bitools/bin/datamodel.sh uploadrpd -I FCCM81.rpd -SI ssi -U <user> -P
<password>
    2. Restart Oracle Analytic Server (OAS) 5.9 from Enterprise Manager by following these steps:

      Figure 7-2 Restarting Oracle Analytic Server (OAS) 5.9

      This image shows the restarting Oracle Analytic Server (OAS) 5.9 screen.
    3. Click the Target navigation icon.
    4. Expand the Business Intelligence section and then click biinstance.
    5. Click the Availability tab.
    6. Click Stop All.
    7. Click Start All.

Configuring TreeMap Graph

To configure the TreeMap Graph, follow these steps:

  1. Login to Oracle Analytic Server (OAS) 5.9.
  2. Navigate to ORACLE ANALYTIC SERVER (OAS) 5.9 Home.

    Note:

    ORACLE ANALYTIC SERVER (OAS) 5.9 Home is the ORACLE ANALYTIC SERVER (OAS) 5.9 installed path.
  3. Execute the command: 
    cd <Oracle Analytic Server (OAS)5.9_home>
    .
  4. Execute the command to find the available treemap-canvas.js: 
    find -nametreemap- canvas.js
    .
  5. Four different files, all named treemap-canvas.js are displayed.
  6. Back up these four files.
  7. Edit window.top.console to console in these four files and save.

Disable Single Sign On

Execute the following to disable Single Sign On:
<Oracle Analytic Server (OAS) 5.9_Home>/oracle_common/common/bin/wlst.sh
        disableBISingleSignOn('<Oracle Analytic Server (OAS)5.9_Home>/user_projects/ domains/bi').

Enabling Table Authentication feature in OAS 5.9

To enable Table authentication, follow these steps:

  1. Go to the following location and open or create the .properties file.

    <DOMAIN_HOME(OAS Server Domain home)>/config/fmwconfig/biconfig/OBIPS/incubation.properties (if the file does not exist, create it).

  2. Add/update the oracle.bips.auth.nextGenAuth=false line in the file.
  3. Restart the OBIPS process(es).

    For example:

    • <DOMAIN_HOME>/bitools/bin/stop.sh -iobips1
    • <DOMAIN_HOME>/bitools/bin/start.sh -iobips1.