Returns a name or caption for a member or members used by Flex Reporting.
Syntax
XL3FlexMember( Connection, Hierarchy, Member, Flex Path, [Flexset Level] )
Parameters
| Parameter | Description |
| Connection | Connection number to use. |
| Hierarchy | Name of the hierarchy that the member applies to for example 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. |
Example
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" )