In the current perspectives subset editor if you select elements and do ctrl+n and then ctrl+v you get the MDX references for the elements selected.
Can come in pretty handy.
You can thank my bad tping for this tip!
Tip of the Day - Ctrl+N and MDX
- Steve Rowe
- Site Admin
- Posts: 2455
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: TM1 v6,v7,v8,v9,v10,v11+PAW
- Excel Version: Nearly all of them
Tip of the Day - Ctrl+N and MDX
Technical Director
www.infocat.co.uk
www.infocat.co.uk
-
- MVP
- Posts: 3222
- 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: Tip of the Day - Ctrl+N and MDX
Thanks!
Indeed, we can reference elements in a dimension like that.
{[dimension].[element]}
The part in the middle is the result of ctrl-n, ctrl-v.
I have seen people using TM1SubsetAll, Hierarchize, TM1FilterByLevel, TM1FilterByPattern on the exact same element string without wildcards, just to end up with the same 1 element

Indeed, we can reference elements in a dimension like that.
{[dimension].[element]}
The part in the middle is the result of ctrl-n, ctrl-v.
I have seen people using TM1SubsetAll, Hierarchize, TM1FilterByLevel, TM1FilterByPattern on the exact same element string without wildcards, just to end up with the same 1 element


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
- rafaewolie
- Posts: 22
- Joined: Wed May 11, 2016 2:16 pm
- OLAP Product: IBM Cognos TM1
- Version: TM1 PA 2.0
- Excel Version: Excel 2013
- Location: Anywhere, BR
- Contact:
Re: Tip of the Day - Ctrl+N and MDX
Very Usefull, thanks for the tip