Share via


UnaryOperatorColumn (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 UnaryOperatorColumn property of the Level interface contains the name of a column that stores mathematical operators serving as member-specific rollup instructions for a specified level.

Applies To:clsAggregationLevel, clsCubeLevel, clsDatabaseLevel, clsPartitionLevel

Data Type

String

Access

Access depends on the value of the ClassType property of the object.

ClassType

Access

clsDatabaseLevel

R/W

clsCubeLevel

R

clsPartitionLevel

R

clsAggregationLevel

R

Remarks

The UnaryOperatorColumn property provides a simple way to control how member values are rolled up to the values of their parents. When the value of this property is assigned to the name of a column, the contents of that column are used as the unary operator for the member. This unary operator is applied to the member when evaluating the value of the member's parent.

This property provides similar but simplified functionality of the CustomRollupColumnproperty. In comparison to the CustomRollupColumn property, which uses Multidimensional Expressions (MDX) expressions to determine how the member itself is evaluated, the UnaryOperatorColumn contains simple math operators to determine how the value of a member affects the parent. This property may be overridden by the values in the column specified in the CustomRollupColumn property. However, the UnaryOperatorColumn property overrides the CustomRollupExpression property.

The following table lists available unary operators and describes how they behave.

Unary operator

Description

+

The value of the member is added to the aggregate value of the preceding sibling members.

-

The value of the member is subtracted from the aggregate value of the preceding sibling members.

*

The value of the member is multiplied by the aggregate value of the preceding sibling members.

/

The value of the member is divided by the aggregate value of the preceding sibling members.

~

The value of the member is ignored.

Blank values and any other values not found in the table are treated as the plus sign (+) unary operator. There is no operator precedence, so the order of members among their siblings is important.