How to fetch unique value using textlist function from child level to parent level



I need help to get unique values using textlist

There is System module SYS01 at child level dimension with List A, I need fetch text value from line item X in SYS01 to Line item Y in SYS02 . The SYS02 module has dimension B which is parent of list A.

While using Textlist function Im getting error: 'SYS01'.Parent is not recognized as a hierarchy in the model.

The TEXTLIST function should take a hierarchy as argument.

The formula Im using is:

TEXTLIST('SYS01'.X , "," , 'SYS01'.Parent , UNIQUE)

The Parent line item is having list B format in SYS01 module


Best Answer