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!