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.
- Click OK, and then click OK again to save.