SPLITELEMENTNAMES

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 report 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(reference of cell that contains the row)

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])