A question on STET rules

Post Reply
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

A question on STET rules

Post 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
Edward Stuart
Community Contributor
Posts: 248
Joined: Tue Nov 01, 2011 10:31 am
OLAP Product: TM1
Version: All
Excel Version: All
Location: Manchester
Contact:

Re: A question on STET rules

Post 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
mvaspal
Community Contributor
Posts: 341
Joined: Wed Nov 03, 2010 9:16 pm
OLAP Product: tm1
Version: 10 2 2 - 2.0.5
Excel Version: From 2007 to 2013
Location: Earth

Re: A question on STET rules

Post 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
Post Reply