MDX FilterbyPattern
Posted: Thu Sep 22, 2011 7:56 am
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.
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.