Dynamic subset to select all leaf-level elements, except one

Post Reply
jamesbennett
Posts: 28
Joined: Wed Aug 08, 2018 10:01 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2016

Dynamic subset to select all leaf-level elements, except one

Post 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?
User avatar
Steve Rowe
Site Admin
Posts: 2407
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Dynamic subset to select all leaf-level elements, except one

Post by Steve Rowe »

Except is the function you are looking for
Technical Director
www.infocat.co.uk
jamesbennett
Posts: 28
Joined: Wed Aug 08, 2018 10:01 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2016

Re: Dynamic subset to select all leaf-level elements, except one

Post by jamesbennett »

Thanks you - that works now.
Wim Gielis
MVP
Posts: 3098
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.0.9.18
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Dynamic subset to select all leaf-level elements, except one

Post 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.
Best regards,

Wim Gielis

IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
jamesbennett
Posts: 28
Joined: Wed Aug 08, 2018 10:01 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2
Excel Version: 2016

Re: Dynamic subset to select all leaf-level elements, except one

Post 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!
Post Reply