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.
MDX FilterbyPattern
-
- 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
-
- 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
How about this one:
Code: Select all
{ EXCEPT( {TM1SUBSETALL( [}Processes] )}, {TM1FILTERBYPATTERN( {TM1SUBSETALL( [}Processes] )}, "}*")}) }
-
- 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
Thanks. It works perfectly!