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:

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.
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.
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
In the Dashboards drop-down list, click Disclosure Reports to open the dashboard.
Click Edit on any of the reports to open the settings window.
In the Criteria tab, in the Selected Columns pane, click the Onerous Classification Code.
Click Settings to open the settings submenu.

Figure 3-2 The Settings icon adjacent to the Onerous Classification Code
Click Edit Formula to open the Edit Column Formula window.

Figure 3-3 The Edit Column Formula
In the Variables drop-down list, select Global… to open the Insert Global Variable window.
Select the Global Variable that you want to edit, and then click Edit Global Variable.

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.