RFE 101441-Sandboxes to allow overwrite of Cell Security
Posted: 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...
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...