Page 1 of 1

Tip of the Day - Ctrl+N and MDX

Posted: Fri Mar 03, 2017 11:52 am
by Steve Rowe
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!

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

Posted: Sat Mar 11, 2017 8:59 am
by Wim Gielis
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

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

Posted: Wed Sep 06, 2017 6:32 pm
by rafaewolie
Very Usefull, thanks for the tip