7.21.1 OBIEE Configuration - Deploy OFS CRA Analytics

The OFS CRA 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 CRA 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.

Follow these steps to configure the OFS CRA Analytics:

1. Make sure Oracle Business Intelligence 12.2.1.4.0 or OAS 5.5.0 installation is completed and available. See Installing and Configuring Oracle Business Intelligence 12c (12.2.1.4) (E91876-03) or Installing and Configuring Oracle Analytics Server 5.5.0 (F27232-03) 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 Username 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 7-9 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 in the server where the BI client tools are installed:
      • $FIC_HOME/OFS_CRA_DASHBOARDS/12.2.1.4.0/datamodel directory containing the CRMBI.rpd file in the Data Model Directory.
      • CRMBI.catalog file in the $FIC_HOME/OFS_CRA_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 BI Administration .
   3. Select File , select Open , select Offline , and then select the CRMBI.rpd file.
   4. In the Open dialog box, select and open the CRMBI.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 : CRMBI 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=<Databas e 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 CRMBITRANS and CRMBI_INIT_BLOCK and CRMBI.
         • 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 .
      7. 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 Credit Risk Analytics application using the

   URL: http:// <ipaddress>:<port>/analytics (replace the port number based on your setup).

5. 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>.

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

   4. Insert the following code within the XML tag <Views> </Views>.

      <Views> </Views>

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

   5. Insert the following code within the XML tag

      <Views> </Views>
      <Pivot>
      <DefaultRowsDisplayedInDelivery>70000
      </DefaultRowsDisplayedInDelivery>
      <DefaultRowsDisplayedInDownload>70000
      </DefaultRowsDisplayedInDownload>
      <DisableAutoPreview>false</DisableAutoPreview>
      <MaxCells>10000000</MaxCells>
      <MaxVisibleRows>140000</MaxVisibleRows>
      <MaxVisibleSections>600000</MaxVisibleSections>
      <MaxVisibleColumns>50000</MaxVisibleColumns>
      <MaxVisiblePages>10000</MaxVisiblePages>
      </Pivot>

   6. Insert the following code within the XML tag

      <Views> </Views>
      <Cube>
      <CubeMaxRecords>10000000</CubeMaxRecords>
      </Cube>

   7. Insert the following code within the XML tag

      <Views> </Views>
      <Charts>
      <MaxVisibleColumns>50000</MaxVisibleColumns>
      <MaxVisiblePages>600000</MaxVisiblePages>
      <MaxVisibleRows>900000</MaxVisibleRows>
      <MaxVisibleSections>600000</MaxVisibleSections>
      </Charts>

   8. Save and close the file.
6. Perform the following OBIEE BI server configuration steps:
   1. Navigate to the <<Oracle BI Instance Home>/config/fmwconfig/biconfig/OBIS directory.
   2. Edit the NQSConfig.INI file.
   3. Update the following code within the NQSConfig.INI file

      NULL_VALUES_SORT_FIRST = ON;

7. Save the file and restart the BI services.

   Note:

   Take a backup of the instanceconfig.xml and NQSConfig.INI files before making any changes.