RFE 101441-Sandboxes to allow overwrite of Cell Security

Suggest and discuss enhancements for TM1
Post Reply
User avatar
gtonkin
MVP
Posts: 512
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

RFE 101441-Sandboxes to allow overwrite of Cell Security

Post by gtonkin » Mon Feb 13, 2017 2:50 pm

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...
Last edited by gtonkin on Thu Feb 23, 2017 8:52 am, edited 1 time in total.

Gabor
MVP
Posts: 169
Joined: Fri Dec 10, 2010 4:07 pm
OLAP Product: TM1
Version: [2.x ...] 10.2.2
Excel Version: Excel 2010-2013
Location: Germany

Re: What-If scenarios with Sandboxes

Post by Gabor » Mon Feb 13, 2017 5:22 pm

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.

Wim Gielis
MVP
Posts: 1538
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1
Version: PAL 2.0
Excel Version: 2016
Location: Brussels, Belgium
Contact:

Re: What-If scenarios with Sandboxes

Post by Wim Gielis » Wed Feb 15, 2017 12:55 pm

For me as well, +1 !
Best regards,

Wim Gielis

Excel Most Valuable Professional, 2011-2014
http://www.wimgielis.com ==> 103 TM1 articles and a lot of custom code
Newest blog article: TM1 message log analysis with Power Query

User avatar
gtonkin
MVP
Posts: 512
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

RFE 101441-Sandboxes to allow overwrite of Cell Security

Post by gtonkin » Thu Feb 23, 2017 8:52 am

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

User avatar
jim wood
Site Admin
Posts: 3494
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: RFE 101441-Sandboxes to allow overwrite of Cell Security

Post by jim wood » Thu Feb 23, 2017 1:01 pm

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

User avatar
gtonkin
MVP
Posts: 512
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: RFE 101441-Sandboxes to allow overwrite of Cell Security

Post by gtonkin » Thu Feb 23, 2017 1:07 pm

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.

User avatar
jim wood
Site Admin
Posts: 3494
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: RFE 101441-Sandboxes to allow overwrite of Cell Security

Post by jim wood » Fri Feb 24, 2017 1:20 pm

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 7 64-bit. TM1 Version: 10.1.1

User avatar
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

Post by George Regateiro » Tue Feb 28, 2017 9:04 pm

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.

User avatar
gtonkin
MVP
Posts: 512
Joined: Thu May 06, 2010 3:03 pm
OLAP Product: TM1
Version: PAL 2.0.1
Excel Version: 2016 64-bit
Location: JHB, South Africa
Contact:

Re: RFE 101441-Sandboxes to allow overwrite of Cell Security

Post by gtonkin » Wed Mar 01, 2017 6:39 am

Thanks George-appreciated-hopefully we will hit the radar! 8 Votes and counting.

Post Reply