picklist with aliases

Post Reply
Posts: 43
Joined: Thu Oct 22, 2009 7:58 am
OLAP Product: TM1
Version: 9.5.1
Excel Version: 2007

picklist with aliases

Post by nicola531 » Thu Apr 01, 2010 3:18 pm

Hello everybody,

a question: is that possible using picklist with Aliases instead of members?
I want to show the description instead of the real member but I only found this sintax.


thanks in advance for you help,


Posts: 27
Joined: Wed Mar 17, 2010 2:41 pm
OLAP Product: TM1, Transformer, EP, MSAS
Version: 2.0.6
Excel Version: 2016
Location: Russian Federation

Re: picklist with aliases

Post by asvlad » Mon Apr 05, 2010 6:26 am

you can use "Subsets", which have been saved with useing aliases

Wim Gielis
Posts: 2456
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium

Re: picklist with aliases

Post by Wim Gielis » Mon Apr 05, 2010 8:16 am

Are you doing this in the Subset Editor or Excel?

If you are in the case of the former, follow the advice of asvlad. If you are in the case of the latter, use the SUBNM function.
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 112 TM1 articles and a lot of custom code
Newest blog article: Selecting elements in the Subset Editor quickly

Post Reply