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
How to lock TM1 cube cell to avoid write back?
-
- Posts: 15
- Joined: Fri Mar 08, 2013 9:06 pm
- OLAP Product: TM1, Transformer
- Version: 10.1.1
- Excel Version: 2013
-
- 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?
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.
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
-
- 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?
Thanks a lot that would help me!!