Skip to Content
0
Jun 27, 2022 at 03:41 PM

SAP Analytics Cloud: Use Variable Value in Cross Calculations

138 Views Last edit Jun 27, 2022 at 06:36 PM 2 rev

Hello

Hoping someone could help me to resolve a situation with dynamic calculations on SAP Analytics Cloud.

Basically , I have 3 Cross Calculations. The first 2 are restrictions on the individual measures but the 3rd one should be a calculation of Cross Calculation 1 * [User Input]. To cater for the user input, I have create a variable on the model but this variable cannot be directly referenced in the cross calculations, or even story calculations.crosscalc2.png

I have tried to created a measure in the model that references the variable but that also cannot be referenced in a cross calculation.

I can do static calculations like Cross Calculation 1 * 10 but cannot find a way to do this dynamically ,where I can change 10 to 20 etc..

The user input should reflect on each row.

Do you know of anyway to reference the value from the variable prompt directly in a cross calculation or an alternative way to do this?

Thank you so much for taking some time to look at this post.

Best Regards

Attachments

crosscalc.png (12.5 kB)
crosscalc.png (12.5 kB)
crosscalc2.png (12.1 kB)