How to lock TM1 cube cell to avoid write back?

Post Reply
hunterforcognos
Posts: 15
Joined: Fri Mar 08, 2013 9:06 pm
OLAP Product: TM1, Transformer
Version: 10.1.1
Excel Version: 2013

How to lock TM1 cube cell to avoid write back?

Post 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
declanr
MVP
Posts: 1828
Joined: Mon Dec 05, 2011 11:51 am
OLAP Product: Cognos TM1
Version: PA2.0 and most of the old ones
Excel Version: All of em
Location: Manchester, United Kingdom
Contact:

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

Post 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.
Declan Rodger
hunterforcognos
Posts: 15
Joined: Fri Mar 08, 2013 9:06 pm
OLAP Product: TM1, Transformer
Version: 10.1.1
Excel Version: 2013

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

Post by hunterforcognos »

Thanks a lot that would help me!!
Post Reply