ActivityMeasure Property
Syntax
Measure .ActivityMeasure
Applies To
Discussion
You can define a measure that counts categories. For example, you can create a measure that shows how many different customers bought a specific product each month, quarter, or year. Based on a unique level (such as Customer No.), this count includes all non-missing, non-zero values, but does not double-count. For example, if the same customer buys a product twice in the same quarterly period, the quarterly rollup counts that customer only once.
Use the ActivityMeasure property to specify a particular activity measure for a category count. If it is not specified, all measures in the model that meet the criteria are used to generate results.
An activity measure cannot be a calculated measure, an after-rollup measure, or an externally rolled-up measure.
To create a category count measure, add a measure to the measures collection and set the CategoryCountLevel property to the level at which categories are to be counted. The level specified must be unique.
A COM exception is thrown in error situations. The message that is passed with the exception varies depending on the error situation.
Type
Object - Measure
Access
Read/Write
Examples
objMeasure.CategoryCountLevel = objLevelobjMeasure.ActivityMeasure
= objActMeasure