TM1 Forum

Hi
I am struggling with the follwoing rule issue and wonder if anyone may help me:

I would like to put
- either zero at the string consolidation level elements when direct child elements (string) have no value entered,
- either 1 when any of n-level (child) elements has string value entered.

Could anyone help me ?
Thanks

The best way to solve this would be to use TI.
Create a view on all level-0 elements and in case any value comes across write the '1' to the parent.

Really bad idea to do this with a rule. String rules are 1) slow, and 2) never cached. If this is anything other than a simple lookup cube then you should populate with TI.

I'm assuming that the cube is for string entry of some sort; for example you have an org hierarchy and they feedback comments.
But rather than having them type something into a consolidated level you just want a flag to know if they have put anything at the leaf levels below it.

If so I would take note of Tomok's advice on String rules but from a simple practicality if you do want to do it; just add another hidden numeric measure is a rule derived at the N-level to flag a 1 if there is a comment and 0 if not.
Then your string measure has a C-level rule that says if the numeric is 0 then '0' otherwise '1'.

Prefect (brilliant) idea with hidden numeric measure
Never thought about it
Thanks a lot