CategoryCountLevel Property

The CategoryCountLevel property sets or returns the Level object to which a category count applies.

Syntax

Measure .CategoryCountLevel

Applies To

Measure Object

Discussion

You can define a measure that counts categories. For example, you can create a measure that shows how many customers of each type bought a specific product each month, quarter or year.

Use this property to specify which level a category count measure applies to. Transformer excludes non-missing or non-zero categories from the count. The category count becomes the numeric value of the measure.

After this property is set, the MeasureType property returns a value of trCountMeasure. A category count measure derives values from counting categories, and cannot use an association or expression to derive values.

Ensure that the Unique property for the level or date level is set to True before you set this property.

A COM exception is thrown in error situations. The message that is passed with the exception varies depending on the error situation.

Type

Object

Access

Read/Write

Examples

objMeasure.CategoryCountLevel = objLevelobjMeasure.CategoryCountLevel
= objLevel