GETOLAPNAMEA

This function returns an array of the Name attributes from an array of OLAP metadata hierarchy elements.

The function requires the unique names of the elements.

If only one unique name is specified, the function behaves as GETOLAPNAME.

Syntax

=GETOLAPNAMEA("uniquename" {,"uniquename"})

G7 contains this array of two unique names of elements:

#("[repository].[bestpracticesolap].[analysis].[pos].[pos].[pos].[all]","[repository].[bestpracticesolap].[analysis]")

This example returns #("[POS].[All]","Analysis").

=GETOLAPNAME(G7)