Skip to Content

I am sure several of you still remember a typical use case of SAP BusinessObjects Dashboards (former Xcelsius), where customers used the product to create a What If Simulation.

 

So I thought it is about time to show, how simple such a scenario could be realized today using SAP Analytics Cloud.

 

You can find the complete detailed step by step guidance and the source spreadsheet here:

 

SAP Analytic Cloud – What If Simulation – Step by Step guidance

SAP Analytic Cloud – What If Simulation – Source Spreadsheet

 

Enjoy

To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. AMIT KUMAR

    Thanks Ingo for sharing..But looking on document (step by step guidance) so many steps needs to be follow for What-if.I believe it was more easy to implement in Xcelsius.

     

    (1) 
    1. Ingo Hilgefort
      Post author

      Hi Amit,

       

      the steps in Xcelsius were very similar, just at a different “spot”. In Xcelsius you had to create all the formulas in the Excel spreadsheet and then you created the visualization on top.

      So if you wanted to use the data in the spreadsheet, the amount of formulas compared to SAP Analytics Cloud would be very similar.

      If you wanted to create this on top of Live data – lets say HANA – you would have to create more formulas in Xcelsius compared to SAP Analytics Cloud.

      On top – Xcelsius has no concept of Actual vs Plan in regards to the data.

       

      Regards

      Ingo Hilgefort, SAP

      (1) 

Leave a Reply