CalculatedMember Members
Include Protected Members
Include Inherited Members
Represents the calculated fields and calculated items for PivotTables with Online Analytical Processing (OLAP) data sources.
The CalculatedMember type exposes the following members.
Properties
| Name | Description | |
|---|---|---|
.gif "Public property") |
_Default | Reserved for internal use. |
|
Application | Returns an Application object that represents the Microsoft Excel application. |
|
Creator | Returns a 32-bit integer that indicates the application in which this object was created. |
|
DisplayFolder | Gets the display folder name for a named set. |
|
Dynamic | Gets whether the specified named set is recalculated with every update. |
|
FlattenHierarchies | Gets 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. |
|
Formula | Returns the member's formula in multidimensional expressions (MDX) syntax. |
|
HierarchizeDistinct | Gets 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. |
|
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 the name of the object. |
|
Parent | Returns the parent object for the specified object. |
|
SolveOrder | Returns an Integer specifying the value of the calculated member's solve order MDX (multidimensional expression) argument. The default value is zero. |
|
SourceName | Returns the specified object’s name as it appears in the original source data for the specified PivotTable report. |
|
Type | Returns the calculated member type. |
Top
Methods
| Name | Description | |
|---|---|---|
.gif "Public method") |
Delete | Deletes the object. |
Top