4.1 Deploying FCCM Analytic Reports

This section describes how to deploy Analytics on Oracle Business Intelligence Enterprise Edition (ORACLE ANALYTIC SERVER (OAS) version 24.0) and integrate FCCM Analytic Reports in the OFSBD UI.

Installing OAS Version 24.0

Installing OAS Version 24.0 Windows Administration Client

Disabling Cache Feature in OAS Version 24.0

Change Default Repository Password

Configuring OAS Version 24.0 Connection Pool

Deploying OFS FCCM Report Analytics

Configuring TreeMap Graph

Disabling Single Sign On

Enabling Table Authentication in OAS Version 24.0

Viewing KYC Reports as an Investigation User

To install the ORACLE ANALYTIC SERVER (OAS) version 24.0:

  1. Download the software from ORACLE ANALYTIC SERVER (OAS) 24.0 server.
  2. After installation, get the Enterprise Manager URL, User name, Password, and ORACLE ANALYTIC SERVER (OAS) version 24.0installed directory from your System Administrator.

Download and install OAS Client tool for 24.0.

This section describes how to disable the Cache feature in the Oracle Analytic Server (OAS) version

  • To disable the Cache feature:
    1. Login to the Enterprise Manager.
    2. Click the Target Navigation icon.
    3. Expand the Business Intelligence section and then click bi instance.
    4. Click the Configurationtab.
    5. Click the Lock icon and then click Lock & Edit to enable the Cache Enabledcheck-box.
    6. Under the Performancetab, in the Enable Bi Server Cache section, reselect the Cache Enabled check-box and make the required changes.
    7. Click the Lock icon and then click Release Configuration to save the changes made.

Copy the FCCM8129.rpd from $FIC_HOME/ORACLE ANALYTIC SERVER (OAS)24.0/Repository to the Windows machine where the Oracle Analytic Server (OAS) 24.0 Windows Administration Client is installed.

To change the default password for the repository:

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

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

  4. Enter default Repository password: FCCM$8129.

    To change the default password:

    1. From the File menu, choose Change Password.
    2. Enter the new password and clickOK.

This section describes how to configure the Oracle Analytic Server (OAS) version 24.0 Connection Pool.

To configure the Connection Pool of the repository:

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

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

  2. Expand the FCCM folder in the Physicalsection.
  3. Double-click Connection Pool to open the Connection Pool Propertieswindow.
  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=<DatabaseName>))).
  5. Enter the Atomic Schema user name and password in respective fields.
  6. Click OK.
  7. Expand the folder.
  8. Right-click on any one table name and 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:
    1. KYC Analytics > Atomic Schema

      Note:

      Both the initial block and the connection pool must point to the Atomic Schema.
    2. UIC_73 > CaseMng Connection Pool >Atomic SchemaUIC_73 > Security Connection Pool > Atomic Schema
    3. TA > Atomic Schema
    4. CTRBI > Atomic Schema
    5. ORCL > Atomic Schema
    6. FCCM > Atomic Schema
  10. From the File menu, select Save.

    A confirmation message is displayed.

  11. Click Yes.

    The message: Consistency check didn’t find any errors, warning or best practices violations. is displayed.

  12. Click OK.
To deploy Reports Analytics:
  1. Login to System Settings using the URL:

    http://<oas server name>:<oas analytics port number>/analytics/systemsettings/

    Example link for reference: 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 Malcontent.
  6. Click Restart.
  7. Update the instanceconfig.xml file present in <Oracle Analytic Server (OAS) 24.0_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 FCCM8129.rpd into the working location of OAS server.
    4. Go to: <OAS 24.0 Home directory>/Oracle_Home/user_projects/domains/bi/bitools/bin.
    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 FCCM8129.rpd.
    1. Navigate to the working directory and execute the following script:

      <Oracle Analytic Server (OAS) 24.0_home>/user_projects/domains/bi/ bitools/bin/datamodel.sh uploadrpd -I FCCM8129.rpd -SI ssi -U <user> -P <password>

    2. Restart the Oracle Analytic Server (OAS) 24.0 from Enterprise Manager by following these steps:
      1. Click the Target Navigation icon.
      2. Expand the Business Intelligence section and then click bi instance.
      3. Click the Availability tab.
      4. Click Stop All.
      5. Click Start All.

      Figure -1 Restarting Oracle Analytic Server (OAS) 24.0


      Description of Figure -1 follows
      Description of "Figure -1 Restarting Oracle Analytic Server (OAS) 24.0"

To configure the TreeMap Graph:
  1. Log into Oracle Analytic Server (OAS)24.0.
  2. Navigate to ORACLE ANALYTIC SERVER (OAS) 24.0 Home.

    Note:

    ORACLE ANALYTIC SERVER (OAS) 24.0 Home is the ORACLE ANALYTIC SERVER (OAS) 24.0 installed path.

  3. Execute the command: 
    cd <Oracle Analytic Server (OAS)24.0_home>
    .
  4. Execute the command to find the available treemap-canvas.js: 
    find -nametreemap- canvas.js
    .

    Four different files (all named treemap-canvas.js) are displayed.

  5. Take back-up of these files.
  6. Edit the .top.console window to console in these four files and save.
To disable Single Sign On:
  1. Execute the following command:
    <Oracle Analytics Server 24.0_Home>/commemoration/common/bin/wlst.sh disableBISingleSignOn('<Oracle Analytics Server 24.0_Home>/ user_projects/domains/bi')
    2. Update the instanceconfig.xml file available in <Oracle Analytics Server 24.0_Home>/user_ projects/domains/bi/config/fmwconfig/biconfig/OBIPS location as:

    Add or replace the following script inside <ServerInstance> </ServerInstance>

    For example: 
    <ServerInstance>
<Security>
<InIFrameRenderingMode>allow</InIFrameRenderingMode>
</Security>
</ServerInstance>

    Note:

    While accessing the Statement View report, ensure that the protocol is the same as the one used in OAS.

To enable the Table Authentication feature:

  1. Navigate to <DOMAIN_HOME(OAS Server Domainhome)>/config/fmwconfig/ biconfig/OBIPS/incubation.properties (if this file does not exist, create it).
  2. Add/update the incubation.properties file with the following line:
    oracle.bips.auth.nextGenAuth=false
  3. Restart the OBIPS process(es).
    For example:
    • <DOMAIN_HOME>/bitools/bin/stop.sh -iobips1
    • <DOMAIN_HOME>/bitools/bin/start.sh -iobips1

To view KYC reports as an Investigation User:

  1. Log into Application as sysadmin.
  2. Navigate to Function-Role Map.
  3. For KYCINGATOR role, map the function Reports.
For more information Function-Role Mapping see the Function - Role Map section in Oracle Financial Services Analytical Applications Infrastructure User Guide.