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: 1875
- Joined: Wed May 14, 2008 4:25 pm
- OLAP Product: TM1
- Version: 10.2.2., PAW
- Excel Version: Nearly all of them
-
Wim Gielis
- MVP
- Posts: 1976
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1
- Version: PAL 2.0.6
- Excel Version: 2016 - Office 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
Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 108 TM1 articles and a lot of custom code
Newest blog article: Access to cube cells in TM1
Wim Gielis
Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 108 TM1 articles and a lot of custom code
Newest blog article: Access to cube cells in TM1
-
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