Page 1 of 1
Dynamic subset to select all leaf-level elements, except one
Posted: Fri Jan 18, 2019 11:48 am
by jamesbennett
I have a dynamic subset set up based on the following expression:
Code: Select all
{TM1FILTERBYLEVEL( {TM1SubsetBasis()}, 0)}
It selects all leaf-level elements within the dimension. Is there a way to modify the expression to remove one particular dimension from the subset?
Re: Dynamic subset to select all leaf-level elements, except one
Posted: Fri Jan 18, 2019 11:52 am
by Steve Rowe
Except is the function you are looking for
Re: Dynamic subset to select all leaf-level elements, except one
Posted: Fri Jan 18, 2019 11:59 am
by jamesbennett
Thanks you - that works now.
Re: Dynamic subset to select all leaf-level elements, except one
Posted: Fri Jan 18, 2019 12:23 pm
by Wim Gielis
jamesbennett wrote: ↑Fri Jan 18, 2019 11:48 am
I have a dynamic subset set up based on the following expression:
Code: Select all
{TM1FILTERBYLEVEL( {TM1SubsetBasis()}, 0)}
It selects all leaf-level elements within the dimension. Is there a way to modify the expression to remove one particular dimension from the subset?
Hello,
Please remove TM1SubsetBasis and use TM1SubsetAll. The former is a relative concept, the latter an absolute one. You will want to have the absolute one, I assume.
Re: Dynamic subset to select all leaf-level elements, except one
Posted: Fri Jan 18, 2019 1:15 pm
by jamesbennett
Wim Gielis wrote: ↑Fri Jan 18, 2019 12:23 pm
Hello,
Please remove TM1SubsetBasis and use TM1SubsetAll. The former is a relative concept, the latter an absolute one. You will want to have the absolute one, I assume.
Thanks for the head's up!