UnaryOperatorColumn (Level Interface)
[!참고]
이 기능은 다음 버전의 Microsoft SQL Server에서 제거됩니다. 새 개발 작업에서는 이 기능을 사용하지 말고, 현재 이 기능을 사용하는 응용 프로그램은 가능한 한 빨리 수정하십시오.
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 |
주의
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.