返回计算成员求解次序的 MDX(多维表达式)参数的值,默认值为零。Long 类型,只读。
expression.SolveOrder
expression 必需。该表达式返回一个 CalculatedMember 对象。
本示例确定计算成员的求解次序,并通知用户。本示例假定数据透视表位于活动工作表上。
Sub CheckSolveOrder()
Dim pvtTable As PivotTable
Set pvtTable = ActiveSheet.PivotTables(1)
' Determine solve order and notify user.
If pvtTable.CalculatedMembers.Item(1).SolveOrder = 0 Then
MsgBox "The solve order is set to the default value."
Else
MsgBox "The solve order is not set to the default value."
End If
End Sub