Page 1 of 1

RFE 66823-Compare Base to one or more Sandbox scenarios

Posted: Fri Feb 20, 2015 9:53 am
by gtonkin
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:
BaseHighVar to BaseLowVar to Base
500,000650,000150,000425,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!

Re: Compare Base to one or more Sandbox scenarios

Posted: Wed Dec 09, 2015 4:54 pm
by jpm_de
CAFÉ Flex views allow for this feature, as the sandbox is the top-most "element".
So at least for Excel Power users it is already in place.

And with CAFÉ being the future of Perspectives, I am hoping to see the same in new front-ends such as Planning Analytics as well...

Re: RFE 66823-Compare Base to one or more Sandbox scenarios

Posted: Tue Jan 10, 2017 2:31 pm
by jpm_de
I still agree with gtonkin when it comes to utilizing sandboxes more easily.

I found this video of Planning Analytics Workspace, which shows how the new (virtual) Hierarchies functionality is leveraged for Sandboxes:
https://www.youtube.com/watch?v=rj-aVE2YQeI