CustomRollupPropertiesColumn (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 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

Osservazioni

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.