RFE 66823-Compare Base to one or more Sandbox scenarios
Posted: Fri Feb 20, 2015 9:53 am
I have logged an RFE for the following as it irks me that you basically have to copy and paste, flip sandboxes, refresh etc. to try do some useful what-if analysis using sandboxes.
When working with sandboxes to compare various what-if scenarios, the user can view the results of the change in the sandbox but cannot easily see a variance or variance percentage to Base or another scenario.
A user has created a sales budget. Sales is part of the Income Statement and the client is creating personal scenarios to see a possible High and Low sales effect on the Income Statement.
The Sales model can be updated with the assumptions and each Sandbox correctly reflects the final impact on the Income Statement's final profit or loss.
What the client cannot do is to compare variances across Base, High and Low in the cube viewer or in Excel e.g.
Profit/Loss:
This applies to both Architect, Perspectives and Web.
Business Analytics is all about What-if and the current implementation of sandboxes cripples this functionality by providing half a solution.
Please vote!
When working with sandboxes to compare various what-if scenarios, the user can view the results of the change in the sandbox but cannot easily see a variance or variance percentage to Base or another scenario.
A user has created a sales budget. Sales is part of the Income Statement and the client is creating personal scenarios to see a possible High and Low sales effect on the Income Statement.
The Sales model can be updated with the assumptions and each Sandbox correctly reflects the final impact on the Income Statement's final profit or loss.
What the client cannot do is to compare variances across Base, High and Low in the cube viewer or in Excel e.g.
Profit/Loss:
Base | High | Var to Base | Low | Var to Base |
500,000 | 650,000 | 150,000 | 425,000 | -75,000 |
This applies to both Architect, Perspectives and Web.
Business Analytics is all about What-if and the current implementation of sandboxes cripples this functionality by providing half a solution.
Please vote!