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