Defining Application Dimension Details

The dimension details differ for each application type. For Public Sector Planning and Budgeting and 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 the Planning application.

  3. In the Target Application summary grid, select an Essbase or Planning application.

  4. Select the Dimension Details tab.

  5. 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.

  6. Optional: Click Refresh Metadata to synchronize the application metadata from the target application.

  7. 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.

  8. 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 FDMEE first processes the mapping for Account dimension, followed by Product, and then by Entity.

  9. For Essbase applications and Profitability and Cost Management only: Select the Create Drill Region.

    The selection of the dimensions to create a drill-region defines the granularity for the drillable region. For example, if you only select the year dimension, you can drill on a cell that at least does not have a null for year.

  10. 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. (Use the Query by Example button. to toggle the filter row.) Then, enter the text to filter.