What-if Analysis in Excel to Anaplan.

Hi, I happened to see a video on Youtube (https://www.youtube.com/watch?v=N924D6tGOG8) where a person introduces the Excel function "What-if analysis - data table" I want to replicate this function in Anaplan where I have similiar variables (values are dependent on both columns and rows). Are there any best practices on these kind of functions? Regards B

Accepted answers

All comments

ArunManickam

@bbolton , Our optimizer can give us only the optimum result, but not all possible results which the Excel "What if" does. Essentially "What if" is a loop of different values for some variables and a resultant is calculated. We can do this in Anaplan, but it will be through model building, you can have the end-users to change the range of values for the variables.

Thanks

Arun

anirudh

Agree with @ArunManickam

Optimizer does not fit this use case. The best way to replicate this what-if analysis is through boolean overrides.

Basically, supply a boolean for each of the drivers, like products sold. If the boolean is checked, then the profit calculation considers a separate line item which is a user input for number of products sold...

AnyaS

hi there. I am happy to share a little sample I did - feel free to email ASkvortsova@allitix.com

Quick Links

Can you help?

Unanswered questions

Prevent end users deleting a list item when using Worksheet in UX.
Hi, I have a worksheet for end users to enter new hires into, for which the list item which persist across versions. I am having an issue where the end user can delete a list item using the grid functionality because the Current Version value is blank, but I want to prevent them deleting them (as data will be lost from…
Introducing Anaplan API Python SDK
Hey everyone, I wanted to share the Anaplan Python SDK with you. It's a Python Library that wraps all Anaplan APIs and makes it easier to interact with Anaplan programmatically. It is mostly designed with Data Integration Scenarios in mind, but it does support all APIs including ALM, SCIM, Audit, and Cloud Works. Please…
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…