Returns a name or caption for a member or members used by Flex Reporting.

XL3FlexMember( Connection, Hierarchy, Member, Flex Path, [Flexset Level] )

ParameterDescription
ConnectionConnection number to use.
HierarchyName of the hierarchy that the member applies to for example Measures or [Customer].[Customer Geography].
MemberComma-delimited list of members to use for the cross section.
Flex PathThe name of the flex path to use for drilling this member.
Flexset levelUsed internally to track the current level when drilling.

This example is based on the Bicycle Sales cube.

The member name W6000/185 is set to drill using the Test Flex Path.

=XL3FlexMember( 1, "Product", "[Product].&[W6000/185]", "Test" )