categories in a level, if new subordinate categories are added, they are
automatically included in the summarized ancestors.
Although applying a summarized view consolidates the records in a cube by
default, you should not use this option as a means of decreasing the size of your
cube. Also, you cannot apply summarized views to a time dimension when the
model contains a measure with Time state rollup applied.
Procedure
1. Open the Categories diagram for the dimension that contains the categories or
level to be summarized and, if you have not already done so, add a dimension
view.
For more information, see “Create a Dimension View” on page 133.
2. In the Dimension pane, select your new view.
3. In the category viewer, select the categories or level to be summarized and,
from the Diagram menu, click Summarize.
This action will omit the descendant categories but retain their combined rollup
value.
4. Open the PowerCube property sheet and click the Dimensions tab.
5. In the Dimensions list, right-click the dimension in which you created the
dimension view and click View.
6. In the Select a View dialog box, select the dimension view that you created,
and click OK twice.
Omit Categories Using Apex
When you create a dimension view and use the Apex option on a selected
category, the resulting cube contains only the apexed category and its immediate
descendants. The ancestors of the category, any siblings, and any descendants of
these siblings are all omitted.
Any special categories that include descendants of the apexed category are
connected to the apexed category as if it were the root category.
For example, suppose you apply the Apex option to the United States category in
the Region dimension. The resulting PowerCube and its associated reports only
show data for the United States and its descendants.
You cannot perform an apex operation at the union with an alternate drill path.
Procedure
1. Open the Categories diagram for the dimension that contains the categories to
be apexed and, if you have not already done so, add a dimension view.
For more information, see “Create a Dimension View” on page 133.
2. In the Dimension pane, select your new view.
138 IBM Cognos Transformer Version 10.1.1: User Guide
To Next Page
Loading...
Need help?
General