3.6.6 Editing Global Variables for OBIEE or OAS

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

1. 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.
2. Log in to OBIEE or OAS by using the URL format (http://<ipaddress>:<port>/analytics) to open the home page.
   
   
   
   
3. In the Dashboard drop-down list, click DisclosureReports to open the dashboard.
4. Click Edit on any of the reports to open the settings window.
5. In the Criteria tab, in the SelectedColumns pane, click OnerousClassificationCode.
6. Click Settingsto open the settings submenu.
   
   
   
   
7. Click the Edit formula to open the Edit Column Formula window.
   
   
   
   
8. In the Variables drop-down list, select Global… to open the InsertGlobalVariable window.
9. Select the Global Variable that you want to edit, and then click Edit Global Variable
10. Edit a global variable with the following details:

    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.

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