Need help in writing TM1 rule

Post Reply
njangid
Posts: 3
Joined: Thu Jul 17, 2014 3:51 am
OLAP Product: Cognos BI,TM1,Datastage
Version: 10.2
Excel Version: 2007

Need help in writing TM1 rule

Post by njangid »

Dear All,

Need help for the following issue.

I have attached a workflow sheet about the application.

While writing the rule for 'Available Budget' field , If the submission status is 'Y' then I want the rule to retain the existing value, else update it with value returned from Temporary cube.
I have tried to use STET function, but it overwrites the current value by '0'.



Thanks
Naresh
Attachments
TM1 Application Summary.xlsx
(11.68 KiB) Downloaded 216 times
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Need help in writing TM1 rule

Post by tomok »

Using STET in a rule will cancel ALL rule calculations for the affected area, not just cancel this specific rule. Using CONTINUE will leave the area open for either 1) another rule or 2) manual input.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
Post Reply