Locking down prior months?
-
- Posts: 52
- Joined: Mon Sep 20, 2010 2:20 pm
- OLAP Product: IBM TM1
- Version: 9.5.1
- Excel Version: 2007 SP2
Locking down prior months?
Is there an easy way in TM1 to lock down prior months? I don't want users to be able to change data in months that are closed. Is there a best practice for this or is changing the security to read only for a given dimension the way to go?
-
- MVP
- Posts: 1822
- 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: Locking down prior months?
What is the particular issue with changing the security in the Month Dimension's element security cube?... it's simply a matter of changing cells from read to write?ChrisF79 wrote:is changing the security to read only for a given dimension the way to go?
If you wanted you could create a TI Process which you run at month end (possibly via a scheduled chore)
Depending how your month ends actually fall (eg. if they are actually by month or 4-4-5 basis etc.) you could set a parameter for "Current Period" either picking up from a specified plan or time stamp (could possibly use now() with a bit of formatting)... if the month end rollover is a bit less regular however you could simply run the process and add the parameter manually.
Regardless the TI would make sure that current and future periods are set to Write and all others are set to read for the required security groups.
ElementSecurityPut Ti function or a CellPutS directly to the }ElementSecurity cube will do, also worth scanning over the SecurityRefresh function in the documentation.
Then of course the }ElementSecurity cube can be updated via rules looking at some sort of control cube.
If you give the more specific problem/dislike you have to the "natural" method I am sure people will be able to give more specific advice.
Declan Rodger
- jim wood
- Site Admin
- Posts: 3957
- Joined: Wed May 14, 2008 1:51 pm
- OLAP Product: TM1
- Version: PA 2.0.7
- Excel Version: Office 365
- Location: 37 East 18th Street New York
- Contact:
Re: Locking down prior months?
The are a few options here but the most common are locking security down by either rules or TI. Either way normally involves using a control cube to dictate what and when lock down. Using rules (on the security control cube) usually means you have to refresh security either manually or via TI. Using the TI method means you don't have to do that but you do have to execute the process.
I hope that helps,
Jim.
I hope that helps,
Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- Posts: 52
- Joined: Mon Sep 20, 2010 2:20 pm
- OLAP Product: IBM TM1
- Version: 9.5.1
- Excel Version: 2007 SP2
Re: Locking down prior months?
Both answers helped a lot. Thanks for the fast reply.