Page 1 of 1

A question on STET rules

Posted: Wed Nov 04, 2020 8:58 am
by mvaspal
Hello,

IIf I have such a rule

Code: Select all

[‘A’] = N: IF([‘B’] = 0 , 0 , STET);
1. Initially, B = 1, so I enter a value to ‘A’, let’s say 1,000
2. B becomes 0 (i.e. manual input or TI)
3. Now A is 0, by rule
4. B is now changed back to 1 again (by manual input or TI)

How reliable is it to get back the original 1,000 in ‘A’? Does it depend on the TM1 release? Does it depend whether the server is restarted or not?
I have seen different behaviour in different tm1 versions, and I'm interested in your experience in how reliably can TM1 store the originally entered values in the "background", and bring it back to the "foreground", once the rule allows it?

Thanks for any help!
Matyas

Re: A question on STET rules

Posted: Wed Nov 04, 2020 9:12 am
by Edward Stuart
Store A and B explicitly and use an additional element C to check if a value is populated

Much clearer and also removes the ambiguity around data input, is far easier to test when you upgrade versions and you know it will work when you upgrade versions

Re: A question on STET rules

Posted: Wed Nov 04, 2020 10:14 am
by mvaspal
Thank you Edward,
yes, that is usually a better approach - at the moment I have a model that I inherited from others, so that's not an option