Partager via

CalculatedMember Members (Excel)

  • Article

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

Methods

Name

Description

Delete

Deletes the object.

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. 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.

Name

Returns a String value that represents the name of the object.

Parent

Returns the parent object for the specified object. 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.