As businesses increasingly rely on data to make informed decisions and drive growth, financial planning and analysis (FP&A) departments play a pivotal role in providing accurate and timely insights. To leverage the power of real-time analysis, data-d...
Are you a SAP Analytics Cloud user responsible for defining business logic and simulation questions? Or perhaps you're a technical or mathematical user involved in creating artifacts and utilizing algorithms to enable advanced simulations? If so, we ...
We are thrilled to announce an exciting joint webinar by SAP and EY, where we will delve into the transformative power of SAP S/4HANA and SAP Analytics Cloud for planning, combined with EY's people-centric approach to finance transformation. Join us ...
There is very little discussion within enterprises when it comes to the value of financial forecasting, as most of us agree it makes sense to look ahead to see where we are going. Despite this overall alignment, how one should forecast is not as clea...
In his book, Integrated Business Planning, Robert Kugel of Ventana Research provides a comprehensive look at the importance of technology in Integrated Business Planning. It involves connecting all the pieces of the business together, from financials...
Hi Alexandra, could you provide some additional detail here? An assumption could be that the data feeding in is not fulfilling the need of 5x, meaning you’d want at least 5x the # of periods you’d want to predict. Please do let us know and we can fur...
Hi Aizhan,Understood, I'd first create a simple calculation to compare against "VarianceBase"IF([d/"planPhase":ProdStage]="Production" ;ResultLookup(["planPhase":Cost] ;[d/"planPhase":ProdStage]="Planning" ) ;IF([d/"planPhase":ProdStage]="Realize" ...
Hi Aizhan,Using the setup as described, a column chart with added variance seems most fitting.I've created an example where the measure is "Cost" and the dimensions are "prodStage" and "Date".Lastly, I add the variance comparing current to previous p...
Hi Karlijn, for your use case I'd recommend generating averages with restricted measures and constant selection within the table itself. Me and anna.burkhardt actually did a blog series on the topic which you can find here.Any further questions feel...
Hi Shilpa,You cannot reference other tables, what you can do is have a restricted measure calculation at the level of the total you'd like to show with constant selection enabled and use this on the second page.Check out this blog series for details ...