Sets
Sets are the basic building blocks of IBM® Cognos® Analysis
for Microsoft Excel. A
set identifies a group of items from a single hierarchy. In IBM Cognos Analysis
for Microsoft Excel, you
can manipulate the individual sets in the crosstab.
Sets may be
- nested or stacked in the crosstab
- used as filters
The following list describes the different kinds of sets you can use.
- Simple
- A single member and its direct dependents one level down.
- Selection-based set
- A collection of individual items that you have explicitly selected. The items or members may be selected from one or more levels from the same hierarchy and are not aggregated.
- Combination set
- A set consisting of more that one simple or selection-based set.