The status identifies the selection of data that will be used in the calculation.
Aggregation: Always aggregate from the base level. If the data is stored at a higher level, then allocate down to the base level first. For a compressed cube, all dimension members must be in status.
Allocation: Select the source members, which contain the data to be aggregated, and the target members, which will receive the allocated values.
Forecast: Select a single level for each dimension. You can allocate and aggregate the forecast data to other levels in separate steps.
Choose
Specifies the dimension from which members are selected.
From
Specifies the name of the hierarchy to use for the dimension. This box is not available if the dimension has no hierarchies.
Displays a list of available members for the specified dimension and hierarchy. Select one or more individual members or a range of members, then use the shuttle buttons to move them to the Selected Members subtab.
The Available Members subtab contains the following buttons:
Collapse All
Collapses all available members to the highest hierarchical level. This button is available only when a hierarchy is specified in the From box.
Expand All
Expands all available members to the lowest hierarchical level. This button is available only when a hierarchy is specified in the From box.
Find
Displays the Find Members dialog box, which allows you to search for particular members from a complete list.
Displays a list of condition templates for the specified dimension.
Displays the list of steps for the selected dimension. A check mark indicates that a step is enabled, that is, it will be used to select or eliminate dimension members.
Identifies the members selected by the current list of enabled steps.
Copyright © 2003, 2007, Oracle. All rights reserved.