Page 1 of 1

How to lock TM1 cube cell to avoid write back?

Posted: Sun Aug 18, 2013 11:22 pm
by hunterforcognos
I am in the process of learning TM1 and after reading various books / articles, I thought of a possible scenario:

TM1 users want to be able to enter their plan data directly into the cube. They use write back functionality to write data directly into TM1 cube view. However, almost all companies have their planning calendar. So, I want to be able to lock those cube cells so that users do not enter data into the cube after a given planning period is over.

Since all of you are experts, I am sure you must have encountered such scenarios many a times. Can some expert please help me answer this question?

Thanks in advance,

Chai

Re: How to lock TM1 cube cell to avoid write back?

Posted: Sun Aug 18, 2013 11:41 pm
by declanr
Element security on your version/time dimensions should do the trick.
Also look at cell security should you wish to be more granular or if you have multiple time dimensions in 1 cube.

Searching this forum or the user guides on security will tell you all you need to know. You can use TI processes or rules to update your security cubes based on the current date vs key dates in your planning cycles, just remember that a security refresh will be needed.

Re: How to lock TM1 cube cell to avoid write back?

Posted: Thu Oct 17, 2013 8:40 pm
by hunterforcognos
Thanks a lot that would help me!!