How to use Cross Calculations | SAP Analytics Cloud Online Training

In this episode we will use SAP Analytics Cloud and learn more about the option to use a Cross Calculation in a Table and in a Chart. We will first use a Cross Calculation to create Restricted Measures for the Current Month and the Previous Month and then calculate the Variance. In the second example we will use the Cross Calculation to create a Rolling Forecast.

Link to the spreadsheet:

Mastering SAP Analytics is focusing on helping you to get started with SAP Analytics Cloud and how to connect to your corporate information and create compelling data visualizations. The focus is on short and simple videos to get you familiar with the features and capabilities of SAP Analytics Cloud and to show you how to use the available product features best possible.

My Products:

[frzzzni]

Hi Ingo, Fantastic job as always. Is there a link where we can download the flat files used for each DailyDoseSAC? This will help us a lot. Me personally. Many thanks.

[dmplfinanceanalyst]

Hi Ingo, thanks for this. I can't see the cross calculation option when clicking the "Add Measures and Dimensions" for the column section. What could the problem be?

[MasaudAkhtar]

When we use dimension how we can validate with respect to GL Accounts Head?

[harichandru]

Hi Ingo,

I have data through the fourth quarter of 2022. For the next three quarters, I need values.

However, while running the rolling forecast for 2023 Q1 Q2, Q3, it produces null numbers.

Is it possible to forecast future values using rolling forecasting? or  only for the duration of the dataset?

[RajeevKumar-qwct]

HI Ingo, after clicking on add calculation, i don't see forecast and rolling forecast option in calculation editor. What could be the reason?