Calculated Member Properties

Name Returns Description

Formula String Read-only. Returns the CalculatedMember's formula in multi dimensional expressions (MDX) syntax

IsValid Boolean Read-only. Indicates whether the specified CalculatedMember object has been successfully instantiated with the OLAP provider during the current session. Will return True even if the PivotTable is not connected to its data source

Name String Returns the name of the object

CalculatedMember Methods

Name Returns Description

SolveOrder Long Read-only. Gets the value of the CalculatedMember's MDX

(multidimensional expression) argument (default is zero)

SourceName String Read-only. Gets the object's name as it appears in the origi nal source data for the specified PivotTable report

Type XlCalculated Read-only. Gets the CalculatedMember object's type

MemberType

0 0

Post a comment