implement and maintain. Because only a subset of the categories is written to the
cube, a cube that implements dimension views often has the advantage of being
smaller and therefore quicker to build and to deploy.
You should keep the following constraints in mind when implementing this
feature:
v You cannot base your partitions on the dimension used to create a dimension
view. If you do, conflicts can result, which in turn may halt the cube creation
process.
v You should not use dimension views as the basis for custom views, as this may
negatively affect auto-partitioning.
For more information about custom views, see Chapter 7, “Adding Security,” on
page 147.
Procedure
1. Open the Categories diagram for the relevant dimension.
Tip: If the Dimensions pane is not showing, click the Dimensions tab.
2. In the Dimension pane, right-click the dimension and click Add New View.
3. In the View name box, type a meaningful name for the dimension view and
click OK.
You can also type a description of the new dimension view in the Description
box.
4. In the category viewer, select the required categories and, from the Diagram
menu, customize the new dimension view by selecting the category actions that
will help you achieve the summarization you want.
For more information, see
v “Omit Categories Using Suppress.”
v “Omit Categories Using Cloak” on page 135.
v “Omit Categories Using Exclude” on page 136.
v “Omit Descendant Categories Using Summarize” on page 137.
v “Omit Categories Using Apex” on page 138.
5. Open the PowerCube property sheet and click the Dimensions tab.
6. In the Dimensions list, right-click the dimension in which you created the
dimension view and click View.
7. In the Select a View dialog box, select the dimension view that you created,
and click OK twice.
Omit Categories Using Suppress
In situations where a category is not required for reporting purposes, but its
ancestor and descendant categories are, you can suppress the category to hide it.
Suppression creates placeholder categories in hierarchies where no values exist for
some categories in a level. The values for the descendants of a suppressed category
are rolled up and retained in the ancestor category.
Suppressed categories, including blank categories, are still included in category
counts. Values associated with them are included in rolled-up measure values.
134 IBM Cognos Transformer Version 10.1.1: User Guide
To Next Page
Loading...
Need help?
General