MDX FilterbyPattern

wanglinyangling

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.

龙创天下

How about this one:
Code: { EXCEPT( {TM1SUBSETALL( [}Processes] )}, {TM1FILTERBYPATTERN( {TM1SUBSETALL( [}Processes] )}, "}*")}) }

wkinki

Thanks. It works perfectly!