RFE 66823-Compare Base to one or more Sandbox scenarios

Suggest and discuss enhancements for TM1
Post Reply
User avatar
gtonkin
MVP
Posts: 532
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 66823-Compare Base to one or more Sandbox scenarios

Post by gtonkin » 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:
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!
Last edited by gtonkin on Mon Mar 14, 2016 3:37 pm, edited 1 time in total.

User avatar
jpm_de
Posts: 22
Joined: Thu Jun 10, 2010 5:19 pm
OLAP Product: TM1
Version: 10.2.2 FP3
Excel Version: 2010

Re: Compare Base to one or more Sandbox scenarios

Post by jpm_de » Wed Dec 09, 2015 4:54 pm

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...
Why TM1? Because ...with great dimensionality there must also come -- great responsibility!
(http://www.quotecounterquote.com/2012/0 ... great.html)

User avatar
jpm_de
Posts: 22
Joined: Thu Jun 10, 2010 5:19 pm
OLAP Product: TM1
Version: 10.2.2 FP3
Excel Version: 2010

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

Post by jpm_de » Tue Jan 10, 2017 2:31 pm

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
Why TM1? Because ...with great dimensionality there must also come -- great responsibility!
(http://www.quotecounterquote.com/2012/0 ... great.html)

Post Reply