UnaryOperatorColumn (Level Interface)
.gif "ms134699.note(zh-cn,SQL.90).gif") 注意： |
|---|
| 下一版本的 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.
请参阅
参考
CustomRollupColumn (Level Interface)
Level Interface