CalculatedMember Object Members

  • Article
Excel Developer Reference

Represents the calculated fields and calculated items for PivotTables with Online Analytical Processing (OLAP) data sources.

Methods

  Name Description
Bb255869.methods(en-us,office.12).gif Delete Deletes the object.

Properties

  Name Description
Bb255869.properties(en-us,office.12).gif Application When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only.
Bb255869.properties(en-us,office.12).gif Formula Returns a String value that represents the member's formula in multidimensional expressions (MDX) syntax.
Bb255869.properties(en-us,office.12).gif IsValid Returns a Boolean that indicates whether the specified calculated member has been successfully instantiated with the OLAP provider during the current session.
Bb255869.properties(en-us,office.12).gif Name Returns a String value that represents the name of the object.
Bb255869.properties(en-us,office.12).gif Parent Returns the parent object for the specified object. Read-only.
Bb255869.properties(en-us,office.12).gif SolveOrder Returns a Long specifying the value of the calculated member's solve order MDX (Mulitdimensional Expression) argument. The default value is zero. Read-only.
Bb255869.properties(en-us,office.12).gif SourceName Returns a String value that represents the specified object’s name as it appears in the original source data for the specified PivotTable report.
Bb255869.properties(en-us,office.12).gif Type Returns a XlCalculatedMemberType value that represents the calculated member type.