3.2 Post Installation Steps

Editing Global Variables for OBIEE or OAS

To edit the global variables for OBIEE, in this release of the Oracle Insurance Accounting Analyzer Extension Pack Application, follow these steps:

1. Deploy the RPD. For more information, see the OBIEE Configuration - Deploy OFS IIA Analytics section in the Release 8.1.2.0.0 Oracle Insurance Accounting Analyzer Installation Guide.
   1. Ensure that you navigate to the RPD and Catalog folders available in the following directories. Copy the RPD and required Catalog files (as per the license agreement) to the server where the BI client tools are installed:
   2. The $FIC_HOME/IAAEPBI/OBIEE 12.2.1.4.0/Repository directory contains the EP_IFRS17.rpd.
   3. The $FIC_HOME/IAAEPBI/OBIEE 12.2.1.4.0/Catalog directory contains the EP_IFRS17.catalog.
2. Host the RPD in the server where you have configured OBIEE or OAS and Catalog for the Oracle Insurance Accounting Analyzer Application as part of this release.
3. Log in to OBIEE or OAS by using the URL format (http://<ipaddress>:<port>/analytics) to open the Home page.

   Figure 3-1 The Analytics Home Page

   
   

   

   
   
4. In the Dashboards drop-down list, click EPDisclosureReports to open the dashboard. For detailed information on the EP IFRS 17 Reports, see the Oracle Insurance Accounting Analyzer Extension Pack Reports on MOS.
5. Click Edit on any of the reports to open the Settings window.
6. In the Criteria tab, in the SelectedColumns pane, click the OnerousClassificationCode.
7. Click Settings to open the settings submenu.
8. Click Edit Formula to open the Edit Column Formula window.
9. In the Variables drop-down list, select Global… to open the InsertGlobalVariable window.
10. Select the Global Variable that you want to edit, and then click EditGlobalVariable.
11. Edit a global variable with the following details:

    Table 3-1 Required Values for the Global Variable

    Field	Value to be added
    Name	denomination
    Type	Text
    Value	case when '@{denomination}{In Thousand}' = 'In Thousand' then 1000 when '@{denomination}{In Thousand}' = 'In Million' then 1000000 else 1 end

    This variable is used to divide all amount values by thousand or million, depending on the selected criteria.

12. Click OK, and then click OK again to save.