SAP Analytics Cloud: Use Variable Value in Cross Calculations

[former_member810379]

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.

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

[William_Yu]

Hi john.smith104,

Model variable should be available for model based calculated measure or account formula.

Best egards, William

[former_member810379]

Thank you for your answer William.

Meaning there is no way to retreive the single value in the story's cross calculation?

[William_Yu]

no, it's not supported.