Editing Global Variables for OBIEE or OAS

To edit the global variables for OBIEE, in this release of the Oracle Financial Services Loan Loss Forecasting and Provisioning application, follow these steps:
  1. Host the RPD in the server where you have configured OBIEE or OAS and Catalog for the Oracle Financial Services Loan Loss Forecasting and Provisioning 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 Dashboards drop-down list, click CECL 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 Criteria (“IFRS 9”).
  6. Click Settings
  7. Click Edit formula to open the Edit Column Formula window.
  8. In the Variables drop-down list, select Global… to open the Insert Global Variable 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:

    Table 6-4 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

    Figure 6-2 The Edit Global Variable Window


    The Edit Global Variable Window

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