Revision as of 13:54, 29 April 2016 by Antonio.remedios (talk) (Examples (based on the Bicycle Sales cube))
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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


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


Parameter Description
Connection Connection number to use
Hierarchy Name of the hierarchy that the member applies to e.g. "Measures" or "[Customer].[Customer Geography]"
Member Comma-delimited list of members to use for the cross section
Flex Path The name of the flex path to use for drilling this member
Flexset level Used internally to track the current level when drilling

Examples (based on the Bicycle Sales cube)

Member name 'W6000/185' set to drill using the "Test" Flex Path

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

See Also