picklist with aliases

Post Reply
nicola531
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.

dimension:Dimension_name


thanks in advance for you help,

Nicola

asvlad
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
MVP
Posts: 2262
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0.8
Excel Version: Office 365 - latest
Location: Brussels, Belgium
Contact:

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
http://www.wimgielis.com ==> 109 TM1 articles and a lot of custom code
Newest blog article: Set up a TM1 model with AutoHotKey as a service or application

Post Reply