Enabling Document Currency

By default, Document currency is excluded from the Currency drop-down list (located in the Preferences tab of the My Accounts dialog window of Oracle Business Intelligence). To include Document currency, you must remove a specific filter from all the following security groups in the RPD:

  To enable document currency:

  1. Start the Oracle BI Administration Tool.

  2. Click Manage, and then Identity.

  3. In the Identity Manager dialog window, click BI Repository.

  4. Select the Application Roles tab.

  5. For each of the security groups in the RPD list above, do the following:

    1. Double-click the security group. . c.

    2. Click Permission, and then select the Data Filters tab.

    3. Remove the following filter in the data filter column:

      AND "Core"."Fact - Preference List"."Currency Preference Code" <> 'Document Currency'

      For example, the original filter:

      "Core"."Fact - Preference List"."Module Code" = 'PROJECT_ AN' AND "Core"."Fact - Preference List"."Currency Preference Flag" in ('W', 'B') AND "Core"."Fact - Preference List"."Currency Preference Code" <> 'Document Currency'

      should become as follows after you remove the filter:

      "Core"."Fact - Preference List"."Module Code" = 'PROJECT_ AN' AND "Core"."Fact - Preference List"."Currency Preference Flag" in ('W', 'B')

  6. Click Save.