TM1 Workflow - Lock submissions
Posted: Wed Sep 04, 2013 9:13 pm
Hi all,
I have a workflow created using TM1's Workflow component (TM1PlanningManager.xla). The worksheet on which the workflow is built is loaded from a TM1 cube. After the data is 'Submit'ed using Workflow's status, the user is still able to edit the cell and the sheet being loaded from the cube has DBWR function for each of the cells; thereby updating the data even after 'Submit' action is performed.
I tried using Excel Macro function for TM1 called RSAVE but didn't get much help. Can anybody please guide me on locking the data submission?
I have a workflow created using TM1's Workflow component (TM1PlanningManager.xla). The worksheet on which the workflow is built is loaded from a TM1 cube. After the data is 'Submit'ed using Workflow's status, the user is still able to edit the cell and the sheet being loaded from the cube has DBWR function for each of the cells; thereby updating the data even after 'Submit' action is performed.
I tried using Excel Macro function for TM1 called RSAVE but didn't get much help. Can anybody please guide me on locking the data submission?