1. Administrator's Guide
  2. Using FDMEE
  3. Administration Tasks
  4. Registering Target Applications
  5. Defining Application Dimension Details

Defining Application Dimension Details

The dimension details differ for each application type. For Oracle Hyperion Public Sector Planning and Budgeting and Oracle Essbase applications, you reclassify the dimensions and change the dimension class, as necessary.

To define dimension details:

  1. On the Setup tab, under Register, select Target Application.
  2. In the Target Application summary grid, select an Essbase or Oracle Hyperion Planning application.
  3. Select the Dimension Details tab.
  4. Select the Target Dimension Class or click Image shows Search button to select the Target Dimension Class for each dimension that is not defined in the application.

    The dimension class is a property that is defined by the dimension type. For example, if you have a Period dimension, the dimension class is also "Period". For Essbase applications, you must specify the appropriate dimension class for Account, Scenario, and Period. For Public Sector Planning and Budgeting applications, you must specify the dimension class for Employee, Position, Job Code, Budget Item, and Element.

  5. Optional: Click Refresh Metadata to synchronize the application metadata from the target application.
  6. In Data Table Column Name, specify the table column name of the column in the staging table (TDATASEG) where the dimension value is stored.

    Click Image shows Search button to search and select a data table column name.

  7. In Sequence, specify the order in which the maps are processed.

    For example, when Account is set to 1, Product is set to 2, and Entity is set to 3, then Oracle Hyperion Financial Data Quality Management, Enterprise Edition first processes the mapping for Account dimension, followed by Product, and then by Entity.

  8. Click Save.

    The target application is ready for use with FDMEE.

Tip:

To edit the dimension details, select the target application, then edit the application or dimension details, as necessary. To filter applications on the Target Application page, ensure that the filter row is displaying above the column headers. (Click Query by Example button. to toggle the filter row.) Then, enter the text to filter.