MDX FilterbyPattern

Post Reply
appleglaze28
Regular Participant
Posts: 269
Joined: Tue Apr 21, 2009 3:43 am
OLAP Product: Cognos TM1, Planning
Version: 9.1 SP3 9.4 MR1 FP1 9.5
Excel Version: 2003

MDX FilterbyPattern

Post by appleglaze28 »

I'm trying to filter the }Process dimension to allow TI to update the security. However, I'm having difficulty adjusting the Expression by adding "EXCEPT" I hope somebody can give me a tip. this would be useful when generating a view that exclude all control items and include new items either in dimension, cubes & process.

EXCEPT(
{TM1FILTERBYPATTERN( {TM1SUBSETALL( [}Processes] )}, "*}*")}
)

its giving me a syntax error.

Asking for helping already cause its giving me a headache on what's wrong with it. Thanks in advance.
jstrygner
MVP
Posts: 195
Joined: Wed Jul 22, 2009 10:35 pm
OLAP Product: TM1
Version: 9.5.2 FP3
Excel Version: 2010

Re: MDX FilterbyPattern

Post by jstrygner »

How about this one:

Code: Select all

{ EXCEPT( {TM1SUBSETALL( [}Processes] )}, {TM1FILTERBYPATTERN( {TM1SUBSETALL( [}Processes] )}, "}*")}) }
appleglaze28
Regular Participant
Posts: 269
Joined: Tue Apr 21, 2009 3:43 am
OLAP Product: Cognos TM1, Planning
Version: 9.1 SP3 9.4 MR1 FP1 9.5
Excel Version: 2003

Re: MDX FilterbyPattern

Post by appleglaze28 »

Thanks. It works perfectly!
Post Reply