CustomRollupColumn (Level Interface)
The CustomRollupColumn property of the Level interface contains the name of the column that stores member-specific rollup instructions.
Applies To
Data Type
String
Access
Access depends on the value of the ClassType property of the object.
| Class type | Access |
|---|---|
| ClsDatabaseLevel | R/W |
| ClsCubeLevel | R |
| ClsPartitionLevel | R |
| ClsAggregationLevel | R |
Remarks
The string values in this column should contain valid Multidimensional Expressions (MDX) expressions. If a column is empty, the corresponding member is calculated normally. If the formula in the column is invalid, a run-time error occurs when a cell value using the member is retrieved.
Order of evaluation among dimensions with custom rollups is determined by the order of the dimensions in the Dimensions collection of the parent cube. Calculated members are always evaluated before custom rollups.
Note Because the DISTINCT COUNT aggregation function does not support custom aggregations, the use of this aggregation function in combination with the CustomRollupExression and CustomRollupColumn properties is not supported. If a cube uses the DISTINCT COUNT aggregation function and any of the dimensions in that cube use either the CustomRollupExpression property or the CustomRollupColumn property then the cube is considered to be invalid. Processing such a cube will raise a validation error with an error code of mderrInvalidCubeDistinctCountWithCustomRollups.
See Also
Custom Rollup Formulas and Custom Member Formulas