COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => TM1 => Topic started by: CAARTI on 08 Feb 2012 10:38:17 PM

Title: HOw to lock data in cube by TI or rule?
Post by: CAARTI on 08 Feb 2012 10:38:17 PM
Hi Tm1 Gurus,
As a workaround for the TM1  workflow on the Tm1 Web, we are trying to create Workflow Staus cube along with Input sheets with Active Buttons to Submit and reject the contribution on the web.
To be more specific. I am running the SUBMIT, REJECT and COMMIT (separate TIs for each) from input sheet and the same status (i.e. Submitted, Rejected and Reserved) against the approval hierarchy node is displayed through the Workflow status cube across respective approvers and contributors group.
Only problem is I am not able to lock the data in data input form in case of Submission or untill the rejection happens by approver.i.e If I login by User who has submitted the data, the data still can be edited, (the same is possible in default Workflow).
If the same is to be achived by TI, how can I do it? Please advice.
Thanks in Advance.
Title: Re: HOw to lock data in cube by TI or rule?
Post by: o22paris on 10 Feb 2012 04:13:38 AM
Hi

I think you should use cellsecurity rules.
Title: Re: HOw to lock data in cube by TI or rule?
Post by: trinhpv.bsd on 26 Aug 2012 01:31:46 PM
Quote from: CAARTI on 08 Feb 2012 10:38:17 PM
Hi Tm1 Gurus,
As a workaround for the TM1  workflow on the Tm1 Web, we are trying to create Workflow Staus cube along with Input sheets with Active Buttons to Submit and reject the contribution on the web.
To be more specific. I am running the SUBMIT, REJECT and COMMIT (separate TIs for each) from input sheet and the same status (i.e. Submitted, Rejected and Reserved) against the approval hierarchy node is displayed through the Workflow status cube across respective approvers and contributors group.
Only problem is I am not able to lock the data in data input form in case of Submission or untill the rejection happens by approver.i.e If I login by User who has submitted the data, the data still can be edited, (the same is possible in default Workflow).
If the same is to be achived by TI, how can I do it? Please advice.
Thanks in Advance.

i have a probem same you !!
Did you solve it ?
Can you help me ??