TM1 Forum

thank you, I solved the issue. I inserted a dimension attribute which is getting populated from the sql dwh and I just filter based on this on in the rule. And it works

so my syntax was ok, I can do something like that in a tm1 rule, so it must be something else. Thank you

please see my edit: I would be happy with just a general example on how to filter out an element.
Something of the equivalent of an sql syntax of:

and left (abc,1) != '2'

It's really the same case. The only difference is that I have another 3 letters as my dimension name. The numbers and the structure and the formula I used is the same. I just want an example of how would one would exclude all the dimension elements which start with a certain character. I know that i...

Hi there, I would need some help with the correct syntax. I have a dimension, let's call it abc. This dimension has the following structure: Total abc all internal abc total internal 1000 1100 total external 2000 2100 2000 3000 3100 What I want to achieve: in the cell security of a cube, I want to e...