SAP Analytics Cloud - Variance Report between dimentions and version

[VirajSaha]

Hello Experts,

I am trying to replicate a BW report. Report structure looks like below:

I am trying to created calculation between dimensions on column and version and date in rows.

Similar to BW setup, we tried to add formulas at the table cell level. Issue is that every time input control on PC or CC or Year changes, formulas stops working.

I tried to use calculated measure, seems like I am not able to get the desired results when with dimensions in rows and column both. Kind of cross cell calculation.

I tried cross calculation, though unable to combine version with account dimensions. All I see is measures (Amount field) from account dimensions under formal.

I have seen this setup in multiple demos from SAP. So I am certain it is possible. Not sure though how to do it.

Thanks.

[DebjitSingha · Accepted solution]

Hello viraj_saha,

You can use "Cross Calculation" for your setup. In-fact cross calculations are built for such requirements. Here is an example similar to yours. Adding Forecast and Actuals by Product Type. You can use budget with actuals in your case.

I have seen similar query recently from others.

This is how the final output would look like. You can switch rows and columns as pre your requirement. Steps below would give you some idea on how to use cross calculations

Steps-

1. Add cross Calculation under rows.

   

2. Locate under rows > Cross Calculation > More> Add Calculation > Restricted Measure for Actuals

   

3. Create restricted measure for Forecast as well:
   
4. Add another calculation under cross calculation. This time it should be Calculated Measure type. Like below-
   

   

5. Now remove Account dimension from rows and leave Cross Calculation.
6. You can change the order of individual Cross Dimensions –

   

7. Now that restricted measure are appearing under calculation you can calculate % contribution and other similar variance.

Hope this helps. Let us know if you have any query around this topic.

Viewers/ readers - If you find above information helpful, feel free to up-vote (arrows on left side).

- Debjit

[VirajSaha · Accepted solution]

Thanks Debjit for your help.
So basically I was missing restricted measure trick.