CalculatedMember.ParentMember property (Excel)

Returns the name of the parent member for the parent hierarchy. Read-only String.

Syntax

expression.ParentMember

expression A variable that represents a CalculatedMember object.

Remarks

The default parent member is determined by whatever has been defined by the cube designer or Analysis Services as the default member of the selected hierarchy. For example, if an "All" member exists for the selected hierarchy, this is typically the default parent member on the cube.

If the selected parent hierarchy does not have an "All" parent member, another default parent member is defined, either by the cube designer or programmatically by Analysis Services. (If a default member is not specified by the cube designer, the Analysis Services engine automatically defines one.)

Property value

STRING

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.