UnaryOperatorColumn (Level Interface)

Analysis Services Programming

Analysis Services Programming

UnaryOperatorColumn (Level Interface)

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 CustomRollupColumn property. 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.

See Also

CustomRollUpColumn

Level Interface