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 »

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 »

you can use "Subsets", which have been saved with useing aliases
Wim Gielis
MVP
Posts: 3233
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: picklist with aliases

Post by Wim Gielis »

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

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply