IBM Cognos, User Manual

Page: 110 / 411

For example, you can create a count to show how many customers of each type
bought a specific product each month, quarter, or year. This count is a
consolidation of all the categories in the unique level Customer Number. For
example, if the same customer buys a product in two months, the quarterly rollup
counts that customer only once.
You should accept the default activity measure All Measures only if you are sure
that no categories are missing measures, and no measure values sum to zero when
they are rolled up to the next higher time period.
You must use the Rollup tab of the Measure property sheet to specify the Activity
measure
for the category count. This
Activity measure
cannot be any of the
following:
v
a before or after-rollup calculated measure
For more information, see “Define When Measures are Calculated” on page 97.
v
an externally rolled up measure
v
another category count measure
v
an allocated measure, if the allocation occurs in the same dimension as the
category count and above the counted categories level
An error message appears if you try to specify any one of these restricted types of
measure as the basis for your count.
You can base category counts on allocated measures if the allocation uses a
constant from a dimension other than the category count dimension. You can also
create category count measures in time-based partitioned cubes, subject to certain
restrictions. To see information about time-based partitioning, consult the index.
Procedure
1. Click the Measures list to make it active and, from the Edit menu, click Insert
Measure .
2. In the Measure name box, enter a name for the measure, and click OK .
The measure name must be unique in the model. By default, the Short name
and Measure label options derive their values from the measure name because
they are set to
<<From Measure Name>>
.
Tip:
Use the original name of the associated source column to make a regular
measure name unique.
3. Select the Type tab and click Category Count .
4. Select an entry from the Dimension and Level drop-down lists.
The level must be unique and situated in the primary drill-down path of the
dimension you have selected.
Tip: Confirm that the Unique option is selected on the Level property sheet,
and that it is true for your data, by checking the scope. For more information,
see “Show the Scope for a Measure” on page 110.
5. Select the Rollup tab and then select a supported Activity measure for the
count.
6.
Define any other attributes of the count, such as the format and click OK .
The category count appears in the Measures list of your model. The resulting
cube and OLAP reports will show the number of non-missing, non-zero
categories for the specified level and
Activity measure .
96
IBM Cognos Transformer Version 10.1.1: User Guide