Hi all,
I developed a simple forecast application where I load actual data from data warehouse and I allow users to insert budget data in order to calculate forecast.
I know that is possible "lock" cells related to actual data but I can't find how I can obtain this (perhaps I don't know the correct keywords in my google search)
I also believe is a common requirement and probably you've talk about this in the forum.
Can you help me, please?
Many thanks in advance
"Lock" Actual Data in a forecast application
-
- MVP
- Posts: 3128
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: "Lock" Actual Data in a forecast application
It’s called ElementSecurity.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
-
- MVP
- Posts: 2832
- Joined: Tue Feb 16, 2010 2:39 pm
- OLAP Product: TM1, Palo
- Version: Beginning of time thru 10.2
- Excel Version: 2003-2007-2010-2013
- Location: Atlanta, GA
- Contact:
Re: "Lock" Actual Data in a forecast application
Element security is the most common way but if you want to protect Actuals from everything, including Admins and TI processes, then you can LOCK it. Open the dimension, select Actuals, right-click and select Security, Lock. Now no one will be able to change Actuals. BTW, you can also lock and unlock via a TI process.
-
- Posts: 7
- Joined: Thu Oct 03, 2019 10:44 am
- OLAP Product: Planning Analtycs
- Version: 2.0.8
- Excel Version: 2013
Re: "Lock" Actual Data in a forecast application
Thank you so much for your replies.
-
- Community Contributor
- Posts: 206
- Joined: Fri Oct 17, 2008 2:40 am
- OLAP Product: TM1, PA , TMVGate
- Version: 2.x
- Excel Version: 36x
- Location: Singapore
- Contact:
Re: "Lock" Actual Data in a forecast application
The usual way I do it is via cellsecurity with rule referencing a locking cube which manages which months are actuals for respective forecast scenario.
With that you have full flexibility of controlling.
Note that this will not work under TI which runs under Admin context and you will need to put in addition code in TI to check the locking cube.
With that you have full flexibility of controlling.
Note that this will not work under TI which runs under Admin context and you will need to put in addition code in TI to check the locking cube.
-
- MVP
- Posts: 3128
- Joined: Mon Dec 29, 2008 6:26 pm
- OLAP Product: TM1, Jedox
- Version: PAL 2.0.9.18
- Excel Version: Microsoft 365
- Location: Brussels, Belgium
- Contact:
Re: "Lock" Actual Data in a forecast application
Indeed. Add to that a cell security cube with less (only the relevant) dimensions and you are good to go.
Best regards,
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Wim Gielis
IBM Champion 2024
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
- jim wood
- Site Admin
- Posts: 3953
- 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: "Lock" Actual Data in a forecast application
The way I've done it in the past and do at the current client is to have actual and forecast as seperate versions. Have an actual flag on the time dimension, then pull via rules actual data in to forecast when the flag is set. This way you lock the actual periods via rules (no security needed) and you can complete a rolling forecast if your requirement changes. Just then set element security for the actual version to read and you're done. Doesn't involve any cell level security.
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