Defining Application Dimension Details

Dimension details differ for each application type. For selected application types, you can 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. Select the Dimension Details tab.
3. Select the Target Dimension Class or click 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 Oracle Essbase applications, you must specify the appropriate dimension class for Account, Scenario, and Period. For Oracle Hyperion Public Sector Planning and Budgeting applications, you must specify the dimension class for Employee, Position, Job Code, Budget Item, and Element.

   For information on Financial Consolidation and Close application dimensions, see Financial Consolidation and Close Supported Dimensions.

4. Optional: Click Refresh Metadata to synchronize the application metadata from the target application.
5. 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 to search and select a data table column name.

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

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

   When you select a dimension in which to a create a drill-region, you can design 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.

   Select the Create Drill Region option if you want to include the dimension in the Drill Region data slice definition. When the dimension is selected during the data load process, the system builds the data slice by including the unique list of values for each of the dimension.

   Note:

   The Drill Region simply defines the cells for which the drill icon is enabled in the Data Forms and SmartView. It is recommended to use a minimum set of dimensions to define the drill region. If a large number of dimensions are included in the drill region, then the size of the drill region becomes large and consumes system resources every time a form is rendered. For Planning applications, use dimensions with small number of members like Scenario, Year, Period, Version to define the drill region. For an Financial Consolidation and Close application, use only the Data Source for defining the drill region.

   If you want to define a more granular drill region with multiple dimensions, then use the Calculation Manager Drill Region page to edit the region definition. You can use member functions like iDescendants to define the region instead of individual members. You can access the drill region by selecting Navigate and then Rules. Then click Database Properties and expand the application and select the cube. Right click and select Drill Through Definition. Edit only the Region definition and do not modify the XML content. If you edit the drill region manually, set the Drill Region option to No in Application Options.

8. Click Save.

   The target application is ready for use with Data Management.

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 to toggle the filter row.) Then, enter the text to filter.