FindAxisMember Property

Microsoft Office Web Components Object Model

Show All

FindAxisMember Property

       

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.

Format  Required PivotMemberFindFormatEnum. Indicates the format used for the Path argument.

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 to return the top member of an axis.