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