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
Need help in writing TM1 rule
-
- 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
- Attachments
-
- TM1 Application Summary.xlsx
- (11.68 KiB) Downloaded 216 times
-
- 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
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.