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
picklist with aliases
-
- 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
you can use "Subsets", which have been saved with useing aliases
-
- 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
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.
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
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