Setting Default Members in the RPD File

Use the Oracle BI EE Administration Tool to set the default member values in the online repository file (FinancialManagementAnalytics.rpd).

The default dimension values for dimensions in the repository file are displayed on the following table.

Table 6. Default Dimension Values for RPD File

Dimension NameDefault Value
Account[None]
Custom1[None]
Custom2[None]
Custom3[None]
Custom4[None]
Entity[None]
ICP (Intercompany)[ICP None]
Period<Period>
Scenario<Scenario>
Value<Entity Currency>
View<Scenario View>
Year<Year>

After completing and submitting the configuration utility, you can view the selected defaults in the OFMA.log file, under the section “HFM Dimension Default Selection Page.”

  To set default members in the RPD file:

  1. From the Oracle BI EE Administration tool, click Open Online.

  2. Enter the Repository Password for the Oracle Financial Management Analytics repository.

  3. Enter the administrator User and Password.

  4. Optional: Select Load all objects on startup.

  5. Click Open.

  6. In the RPD file, under the Physical layer, select HFM, then HFM Application to display all dimensions.

  7. For each dimension in the hierarchy, complete the following steps:

    1. Double-click the Dimension to display the Physical Dimension dialog box.

    2. On the Hierarchies tab, in the Default Member text box, enter the valid corresponding member value from the Financial Management application.

      To view the selections you made during the configuration, view the selected defaults in the OFMA.log file, under the section “HFM Dimension Default Selection Page.”

      Caution!

      If the default values for the dimensions are not entered, errors will be generated in the Oracle Financial Management Analytics reports.

  8. Select Save.

  9. Restart Oracle BI EE to update all changes. See Restarting Oracle BI EE Manually.

    The connection pool, custom dimension names, and other configuration details are updated. The configuration is complete.