UNIQUE function and MUNs

[AJAYC]

Hi All

I am trying to create a Value prompt from a dimension hierarchy which it self is made up of a number of sub-hierarchies, each containing TM1 elements, eg

All Cost Centres
-Cost Centre Group 1
---CC01
---CC02
-Cost Centre Group 2
---CC01
---CC02
---CC03


In the example, I want to base the prompt query on a uniqueness of the elements (CCxx) from a descendants function on the "All Cost Centres", but each element will have a separate MUN meaning I will show all 5 rather than showing three.

Since the data is stored at CCxx level in TM1, I thought that the use of the captions would help, but I can't seem to carry a unique/caption combination in the report expression.

Does anyone have any other suggestions on how the single instance of each cost centre can be presented in the prompt and used in the query ?

Thanks
Ajay

[venkat01]

My guess is to try Auto grouping yes property of the query

Sent from my GT-N8000 using Tapatalk