Tip of the Day - Ctrl+N and MDX

Ideas and tips for enhancing your TM1 application
Post Reply
User avatar
Steve Rowe
Site Admin
Posts: 1687
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

Tip of the Day - Ctrl+N and MDX

Post by Steve Rowe » Fri Mar 03, 2017 11:52 am

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!

Wim Gielis
MVP
Posts: 1568
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: Tip of the Day - Ctrl+N and MDX

Post by Wim Gielis » Sat Mar 11, 2017 8:59 am

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 :shock: :D
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 104 TM1 articles and a lot of custom code
Newest blog article: Delete a cube and its dimensions

User avatar
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

Post by rafaewolie » Wed Sep 06, 2017 6:32 pm

Very Usefull, thanks for the tip

Post Reply