DataAction (Calculation in data action for inflation and price in different versions and dates)

[Ganjos]

Hello team, I am working on a project where I have price and inflation. Inflation(Inflação) is in forecast, and price(preço) is in planning. What I want to do is create a data action that retrieves the price from the source year (2024) and source version (actual) and multiplies it by the inflation of the target year (2025). I have already created the data action, but it is not working. Could you help me resolve this issue?

[William_Yu]

From your screenshot , seems the inflation rate and last year actual are from two different models while the data action in only working on one model... 

[Ganjos]

Hi @William_Yu,

Is it possible to create a Data Action in SAP Analytics Cloud that retrieves data from multiple models? If yes, could you please explain how to achieve this?

Thanks in advance,

Ganjos

[William_Yu]

Of course, you can use cross model copy to bring data over from another model. Or you can use LINK keyword in advanced formula to directly lookup data from another model.

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/a27d8405ac9b4e7bb8e50...

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/812f4d02ac13401d990ce...