Returns a member based on its relationship to the member passed in. Allows you to navigate a hierarchy, moving between members and levels using formulae alone.
You can combine formulas, for example, to move up a hierarchy, then along the level you get to.
Use the Insert Formula > Member Navigate menu or ribbon item to insert the formula using a wizard.
Syntax
XL3MemberNavigate( Connection, Hierarchy, Member or Level, Relationship, [Index], [Hierarchy1], [Member1],…, [Hierarchy100], [Member100] )
Parameters
| Parameter | Description |
| Connection | Connection number to use. |
| Hierarchy | Name of the hierarchy that the member applies to,"[Customer].[Customer Geography]". |
| Member or Level | Members or Level to use as starting position. |
| Relationship | Relationship of the desired member to the Member or Level passed in, see below. |
| Index | Index of the member in the Relationship, meaning depends on the Relationship. |
| Hierarchy1,…, HierarchyN | Name of the hierarchy that the following member applies to for example, "Measures" or "[Customer].[Customer Geography]". |
| Member1,…, MemberN | Either a single member's unique name or an XL3Member formula to specify that only non-empty members should be returned. |
