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