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