how to show a description of member in a mdx .

[manu0521]

Hi ,

I have the elements with alias defined as Description .

How do i automatically select the descriptions ,

{TM1SORT( TM1FILTERBYLEVEL({TM1SUBSETALL( [Cost Centers] )},0), ASC)}

This gives me all members sorted ascending , i want it to show the description of members sorted ascending .
Thanks,

[PavoGa]

Code: Select all

ORDER( TM1FILTERBYLEVEL( TM1SUBSETALL( [Cost Centers] ), 0), [Cost Centers].[Description], ASC)

And select the alias either through the TI code to create the subset or in the subset editor.