Jaa


CustomRollupPropertiesColumn (Level Interface)

Note

  This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

The CustomRollupPropertiesColumn property of the Level interface is used to provide properties associated with the member formulas provided in the CustomRollupColumn property.

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

Remarks

Any properties that can be specified for a calculated member can also be specified for the member formulas. The column assigned to this property should contain a comma-delimited list of the properties, employing the following syntax:

<property identifier> = '<property value>' [, <property identifier> = '<property value>'...]

The <property identifier> contains the name of a valid property, while the <property value> contains the string representation of the value of the specified property. For example, the FORE_COLOR cell property accepts a long integer containing the RGB value of a given color. To set the foreground color of the member to red, the syntax would resemble the following statement.

FORE_COLOR='255'

As with calculated members, these properties are optional. If the CustomRollupColumn property of the Level object is empty, the contents of its CustomRollupPropertiesColumn property are ignored.

See Also

Reference

CustomRollupColumn (Level Interface)
Level Interface

Other Resources

Custom Rollup Operators

Help and Information

Getting SQL Server 2005 Assistance