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?
TM1 Workflow - Lock submissions
-
ViRa
- Regular Participant
- Posts: 155
- Joined: Tue May 14, 2013 1:53 pm
- OLAP Product: Cognos BI, TM1
- Version: 9.5.2 - 10.1.1
- Excel Version: Excel 2003
Re: TM1 Workflow - Lock submissions
I think I need to concentrate on the 'Post TI' and/or 'Post Action TI Process' arguments in the Workflow. I'm working on it...any ideas/suggestions will be helpful though.
-
David Usherwood
- Site Admin
- Posts: 1458
- Joined: Wed May 28, 2008 9:09 am
-
ViRa
- Regular Participant
- Posts: 155
- Joined: Tue May 14, 2013 1:53 pm
- OLAP Product: Cognos BI, TM1
- Version: 9.5.2 - 10.1.1
- Excel Version: Excel 2003
Re: TM1 Workflow - Lock submissions
Responding late...sorry about that.
I've been able to lock the data submission.
Thanks.
I've been able to lock the data submission.
Thanks.