FindAxisMember Property

  • Article

Finds an axis member, given a reference to the member. Returns a PivotAxisMember object.

expression.FindAxisMember(Path, Format)

*expression   * Required. An expression that returns a PivotAxisMember object.

Path   Required String. A variable or string that contains a reference to the member to find.

PivotMemberFindFormatEnum

PivotMemberFindFormatEnum can be one of these PivotMemberFindFormatEnum constants.
plFindFormatMember Not supported for this property.
plFindFormatPathHex Not supported for this property.
plFindFormatPathInt Member reference is a path of indexes. For example, "1\0\5\1".
plFindFormatPathName Member reference is a unique name, or can be a name if unambiguous. For example, "[USA].[Oregon].[Portland]".

Remarks

If the requested member is not found, a PivotAxisMember object with the IsValid property set to False is returned. This allows you to refer to a member that might later be added to the schema.

This property can be used to find a member from the top member of the specified axis. Use the Member property (PivotAxisMember.Axis.Member) to return the top member of an axis.

Applies to | PivotAxisMember Object | PivotColumnMember Object | PivotPageMember Object | PivotRowMember Object

See Also | Find Method | FindColumnMember Property | FindMember Property | FindNext Method | FindPageMember Property | FindRowMember Property