CalculatedMember Properties (Excel)

Article
05/23/2016

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Properties

Name	Description
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.
Creator	Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
DisplayFolder	Returns the display folder name for a named set. Read-only
Dynamic	Returns whether the specified named set is recalculated with every update. Read-only
FlattenHierarchies	Returns or sets whether items from all levels of the hierarchy of the specified named set are displayed in the same field of a PivotTable report based on an OLAP cube. Boolean Read/write
Formula	Returns a String value that represents the member's formula in multidimensional expressions (MDX) syntax.
HierarchizeDistinct	Returns or sets whether to order and remove duplicates when displaying the hierarchy of the specified named set in a PivotTable report based on an OLAP cube. Read/write
IsValid	Returns a Boolean that indicates whether the specified calculated member has been successfully instantiated with the OLAP provider during the current session.
MeasureGroup	Returns the associated measure group. String Read-only
Name	Returns a String value that represents the name of the object.
NumberFormat	Returns a XlCalcMemNumberFormatType value that represents the number format of the calculated member. The default value is xlNumberFormatTypeDefault. Read-only.
Parent	Returns the parent object for the specified object. Read-only.
ParentHierarchy	Returns the name of the current parent hierarchy from the hierarchies that are available on the cube. String Read-only
ParentMember	Returns the name of the parent member for the parent hierarchy. String Read-only
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.
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.
Type	Returns a XlCalculatedMemberType value that represents the calculated member type.