SPLITELEMENTNAMES

This function returns an array that contains the unique names of all the elements in a row. For example, if you have a slice with two row dimensions, the cell in which the slice is placed contains the unique names of two elements, separated by a comma. SPLITELEMENTNAMES creates an array of those two elements.

Syntax

=SPLITELEMENTNAMES("[Element].[Name],[Element].[Name],…"{,"[Element.Name].[Element].[Name],…"})

Example

In this example, cell B24 contains a vertical hyperblock, formed from the rows of a slice. The slice dimensions on the rows are Period and POS.

=SPLITELEMENTNAMES(B24)

This function returns:

#("[Period].[All Years]","[POS].[All POS])