CustomRollupColumn (Level Interface)
[!NOTA]
Questa caratteristica verrà rimossa a partire dalla prossima versione di Microsoft SQL Server. Non utilizzare questa caratteristica in un nuovo progetto di sviluppo e modificare non appena possibile le applicazioni in cui è attualmente implementata.
The CustomRollupColumn property of the Level interface contains the name of the column that stores member-specific rollup instructions.
Applies To:clsAggregationLevel, clsCubeLevel, clsDatabaseLevel, clsPartitionLevel
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 |
Osservazioni
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.
[!NOTA]
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.
Vedere anche