GET.LEAD

This formula returns the name of an element which you specify with the Numeric Expression argument. In this formula, the Numeric Expression argument represents the distance of the required element from an element which you specify and which is at the same level of the hierarchy.

Syntax

=MDX.GET(Database Alias, Cube, "Element Unique Name"&".lead("&n&").name")

where 'n' is the distance of the required element from the specified element.

Note: The Numeric Expression argument is zero-based. That is, if, for example, there are three elements, they are identified as 0,1 and 2.

Arguments to this function can be strings, or references to cells containing strings. If strings, they must be enclosed in quotes.