TM1 Forum

Hi all,

Relatively new to TM1 and also the forum (1st post). Apologies in advance for my newbie type question.

I'm trying to create a filter based dynamic subset that includes all level 0 elements except for elements that begin with "02"

Any suggestions for writing that into the expression window are appreciated!

If you plan on creating MDX-based subsets you should definitely read the MDX Primer http://www.bihints.com/except_and_valid ... ierarchies. EXCEPT is the function you're after.

Hi Tom,

Thanks for the reference. I was able to figure it out using the exception function.

{EXCEPT( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [DIM1] )}, 0)}, {TM1FILTERBYPATTERN( {TM1FILTERBYLEVEL( {TM1SUBSETALL( [DIM1] )}, 0)}, "02*")})}

Hello

I would also use this expression. The alternative with the Instr function I find less interesting.