TM1 Forum

Posted: **Tue Apr 02, 2019 2:29 pm**

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,

Posted: **Tue Apr 02, 2019 3:29 pm**

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.

TM1 Forum

how to show a description of member in a mdx .

how to show a description of member in a mdx .

Re: how to show a description of member in a mdx .