I have a model with various source e.g. Actuals, STP, What-if Base, What-if Final etc.
The idea is that Actuals and STP are secured via security but What-if Base is open for input after being populated from Actuals/STP.
Users can then fiddle around with the numbers in What-if Base before various rules carry these values through to What-if Final or derive ratios etc. into What-if Final. All has been good for the last 8 years within this model and as user "pull levers", so the results change and life is bliss.
What I would like to do for future models is be able to use Sandboxing to do away with the requirements for the various sources and have users change the base values in the sandbox, the rules fire off and the results updated within the sandbox. For most situations, simplistic What-if is required and does not warrant a full node analysis with rules to filter one change to multiple measures and multiple iterations etc.
To do this however means that the underlying source needs to stay read-only whilst the sandbox allows for write but not commit.
Has anyone else had this requirement? Been able to use sandboxes in this way?
Based on the feedback, I may raise an RFE otherwise go back to dreaming...
RFE 101441-Sandboxes to allow overwrite of Cell Security
- gtonkin
- MVP
- Posts: 1202
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
RFE 101441-Sandboxes to allow overwrite of Cell Security
Last edited by gtonkin on Thu Feb 23, 2017 8:52 am, edited 1 time in total.
-
- MVP
- Posts: 170
- Joined: Fri Dec 10, 2010 4:07 pm
- OLAP Product: TM1
- Version: [2.x ...] 11.x / PAL 2.0.9
- Excel Version: Excel 2013-2016
- Location: Germany
Re: What-If scenarios with Sandboxes
I've had this requirement from time to time, but never started to look for a workaround (except traditional what-if dim). Would like to have the ability, so my vote for a RFE.
-
- MVP
- Posts: 3123
- 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: What-If scenarios with Sandboxes
For me as well, +1 !
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
- gtonkin
- MVP
- Posts: 1202
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
RFE 101441-Sandboxes to allow overwrite of Cell Security
OK, so a whopping 3 interested parties. I have logged the RFE being an optimistic soul that others will vote once logged.
RFE 101441-Sandboxes to allow overwrite of Cell Security
RFE 101441-Sandboxes to allow overwrite of Cell Security
- jim wood
- Site Admin
- Posts: 3952
- 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: RFE 101441-Sandboxes to allow overwrite of Cell Security
I've actually had a help desk ticket about this very subject brushed off last year. We have a project finish date that locks down entry for any time after that point. The users in sandbox want to change the date in the sandbox and enter data. They can change the date, but not the data. All access, security or rule based comes from the base. I've been told it how sandboxing was designed and to change it would require a complete rebuild of the functionallity. If they didn't put this in PA I wouldn't hold your breathe. While I'll add a +1 I doubt it will go anywhere soon.
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
- gtonkin
- MVP
- Posts: 1202
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: RFE 101441-Sandboxes to allow overwrite of Cell Security
Thanks for the vote Jim-will definitely not hold my breathe! I would have loved to have been on whichever "group" IBM had when agreeing this new functionality. It would also be great if there was some user group that could give feedback into what IBM is proposing to build in the future, even if I need to sign NDAs etc. This way, people that develop/deploy/use the features would have a say in what the end product should offer.
- jim wood
- Site Admin
- Posts: 3952
- 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: RFE 101441-Sandboxes to allow overwrite of Cell Security
Agreed. I can see why security would be inherited by each sandbox, but values locked by rules? The scenario I mentioned above obviously wasn't taken in to account when the IBogLix boffin created it. It's something they should really think about now. After all a lot of models have actualization of forecast rules. The above stops the user being able to roll back in sandboxes.
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
- George Regateiro
- MVP
- Posts: 326
- Joined: Fri May 16, 2008 3:35 pm
- OLAP Product: TM1
- Version: 10.1.1
- Excel Version: 2007 SP3
- Location: Tampa FL USA
Re: RFE 101441-Sandboxes to allow overwrite of Cell Security
Voted and ask a couple extra people to vote for it. This is something we have talked about with product management for a while but never gained any traction.
- gtonkin
- MVP
- Posts: 1202
- Joined: Thu May 06, 2010 3:03 pm
- OLAP Product: TM1
- Version: Latest and greatest
- Excel Version: Office 365 64-bit
- Location: JHB, South Africa
- Contact:
Re: RFE 101441-Sandboxes to allow overwrite of Cell Security
Thanks George-appreciated-hopefully we will hit the radar! 8 Votes and counting.