OBIEE Configuration – Deploy OFS LRS Analytics

The OFS LRM Analytics application release 8.1.2.0.0 is based upon a dedicated reporting mart built from the new Fusion Financial Services Data Model. OFS LRM Analytics 8.1.2.0.0 leverages several components of Oracle Business Intelligence Enterprise Edition (OBIEE) or Oracle Analytics Server (OAS) technology including Dashboards and Answers. It also includes various Dashboards and Reports for the user to carry out various Liquidity Gap based analytics.

To configure the OFS LRM Analytics:

1. Make sure Oracle Business Intelligence 12.2.1.4.0 or OAS 5.5.0 installation is completed and available. See the Installing and Configuring Oracle Business Intelligence section or the Installing and Configuring Oracle Analytics Server section for more details.
2. Configure the ODBC data source to connect to the Oracle BI Server:
   1. Navigate to Control Panel, select Administrative Tools, and then select Data Sources (ODBC).
   2. Select the System DSN tab and click Add.
   3. Select a driver-specific to Oracle BI Server 2.2.1.4.0 or OAS 5.5 and click Finish.
   4. Enter the Name and Server details (specify the Hostname or IP Address of the BI Server) and click Next.
   5. Enter the Oracle BI Server login ID and password (Enter the User Name and Password created at the time of OBIEE or OAS installation). Update the port with the port number available for the BI Server in the Availability tab of Business Intelligence in the Enterprise Manager.

      For example: In the following figure, the port number is 9514.

      Figure 8-24 Update Port Number in the BI Server

      
      

      

      
      
   6. Click Next.
   7. Navigate to the RPD and Catalog folders available in the following directories. Copy the RPD and required Catalog files (as per the license agreement) in the server where the BI client tools are installed:
      • $FIC_HOME/OFS_LRM_DASHBOARDS/12.2.1.4.0/datamodel directory containing the Liquidity_Risk_Management_Pack.rpd file in the data model directory.
      • Liquidity_Risk_Management_Pack.catalog, Bank of Thailand.catalog, BNM.catalog, Deposit Insurance.catalog, HKMA.catalog, RBI.catalog, and USFED.catalog files in the $FIC_HOME/OFS_LRM_DASHBOARDS/12.2.1.4.0/content/catalog directory.
   8. Click Finish.
3. Modify the connection pool and set the properties.
   1. Open the OBI Administration tool.
   2. Select Start, select Programs, select Oracle Business Intelligence, and then select the BI Administration.
   3. Select File, select Open, select Offline, and then select the Liquidity_Risk_Management_Pack.rpd file.
   4. In the Open dialog box, select and open the Liquidity_Risk_Management_Pack.rpd file.
   5. Enter the Repository password. See the MOS Doc ID: 2691681.1 for the password
   6. In the Physical layer, double-click the Connect Pool: LRMBI to open its properties.
   7. In the General tab, edit and check the following entries:
      1. Call Interface: (OCI 10g/11g).
      2. Data source name: <TNS Entry connecting to OFSAA atomic schema>

         For example: (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<Database IP address>)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=<Database Name>)))

      3. User name: <enter atomic db user name>.
      4. Password: <enter atomic db user password>.
      5. Confirm the password and click OK to close the window.
      6. Similarly, configure the connection pools for LRMBITRANS and LRMBI_INIT_BLOCK and LRMBI.
         • Check Global Consistency, that is, press Ctrl+k.
         • Double-click on the warning (if you are using OAS).
         • Click Reset to defaults and click OK.
         • Click Save.
   8. Click Yes for the Global Consistency Message. No warnings should be generated at this stage.
   9. Close the RPD file (close the file and exit).
4. Log in to the OFS LRM Analytics application using the URL: http:// <ipaddress>:<port>/analytics (replace the port number based on your setup).
5. Follow these steps to configure the BI publisher Data Source:
   1. Log in to the OFS LRM Analytics application
   2. Navigate to Administration, select BI Publisher, and then select Manage BI Publisher.
   3. Click JDBC Connection from Data Sources.
   4. Click Add Data Source.
   5. Enter the Data Source name as LRM.
   6. Add Database details in the Connection string, that is the hostname (IP address), port number, and SID.
   7. Enter the username (schema name) and password.
   8. Click Test Connection.
   9. Ensure that the connection successfully established. Click Apply.
6. Follow these steps to implement the Writeback feature:
   1. Add the tag <LightWriteback>true</LightWriteback> in between <ServerInstance></ServerInstance> in the instanceconfig.xml file.
      For example:

      <ServerInstance>
      <LightWriteback>true</LightWriteback>
      </ServerInstance>

   2. Copy the writeback.xml file available in the $FIC_HOME/OFS_LRM_DASHBOARDS/12.2.1.4.0/content/msgdb/ directory to the following OBIEE server directories. If the customMessages directory is not present, create the directory manually.

      Path1: <BI Domain Home>/bidata/components/OBIPS/custommessages

      For example: /scratch/oraobiee/Oracle/Middleware/Oracle_Home/user_projects/domains/bi/bidata/components/OBIPS/custommessages

      Path2: <BI Domain Home>/bidata/service_instances/ssi/metadata/content/msgdb/l_en/customMessages

      For example:

      /scratch/oraobiee/Oracle/Middleware/Oracle_Home/user_projects/domains/bi/bidata/service_instances/ssi/metadata/content/msgdb/l_en/customMessages
   3. Restart the BI Services.
   4. Login to OBIEE Analytics and navigate to the Administration section on the right top corner.
   5. Click Manage Privileges and scroll down to Writeback.
   6. Grant Writeback to Database privilege to Authenticated User and BI Administrator roles.
7. Perform the following OBIEE presentation server configuration steps:
   1. Navigate to the <<Oracle BI Instance Home>/config/fmwconfig/biconfig/OBIPS directory.
   2. Edit the instanceconfig.xml file.
   3. Insert the following code within the XML tag <Views> </Views>.

      • <Charts>
        <MaxVisibleColumns>50000</MaxVisibleColumns>
        <MaxVisiblePages>25000</MaxVisiblePages>
        <MaxVisibleRows>10000000</MaxVisibleRows>
        <MaxVisibleSections>50000</MaxVisibleSections>
        <JavaHostReadLimitInKB>10240</JavaHostReadLimitInKB> 
        </Charts>

      • <Table>
        <DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
        <DefaultRowsDisplayedInDownload>6500</DefaultRowsDisplayedInDownload>
        <MaxCells>4000000</MaxCells>
        <MaxVisibleRows>140000</MaxVisibleRows>
        </Table>
        <Narrative><MaxRecords>500000</MaxRecords>
        <DefaultRowsDisplayed>25</DefaultRowsDisplayed>
        </Narrative>

   4. Save the file and restart the BI services.

      Note:

      Take a backup of the instanceconfig.xml file before making any changes.