IBM Cognos, User Manual, Page: 169 / 411

Example - Union of Excluded Categories in Two Dimensions
This example describes the union of excluded categories in two dimensions.
Custom view A: exclude Camping Equipment
Custom view B: exclude Asia Pacific
Because custom view A is shown all categories except the Camping Equipment,
and custom view B is shown all categories except Asia Pacific, the union shows all
categories. Each custom view is shown the cells of the siblings of the excluded
categories. The only area not shown is the intersection of the two exclusions:
Camping Equipment and Asia Pacific.
Examples - Unions of Excluded Categories in the Same
Dimension
The following examples describes the union of excluded categories in the same
dimension.
Example 1
Custom view A: exclude Central Europe
Custom view B: exclude Americas
Each custom view is shown the values excluded by the other custom view.
Example 2
Custom view A: exclude France
Custom view B: exclude Central Europe, Mexico
France is the only category that is not shown in either custom view. The other
children of Central Europe, and Mexico are shown to custom view A.
Example 3
Custom view A: exclude France, exclude Americas
Custom view B: exclude Central Europe, exclude Mexico
France and Mexico are not shown in either custom view. The other children of
Americas are shown in custom view B. The other children of Central Europe are
shown to custom view A.
Chapter 7. Adding Security
155