If I run Cross-Model Copy while doing a lot of data mapping in SAC, what should I do?

[satoko_nakayama]

Hi, Experts,

I am trying to create a model of Sales plan and copy it to the model of PL by profit center in SAC.
The sales plan model has a "Material ID" and which has "Profit Center" property.
On the other hand, the PL by profit center model has a "Profit Center" dimension, but there are no dimensions or properties related to "Material ID".

I want to aggregate the sales Amount for each "Material ID" in the Sales Plan by profit center, which is a property of the "Material ID", and copy them to the PL model by Profit Center.

For now, I tried the Cross-Model Copy, a data action.
I was able to do this by using copy rules to map the Material ID to the Profit Center, but I think this is a way to deal with only a small number of target data as below.

If I run Cross-Model Copy while doing a lot of data mapping in SAC, what should I do?

SAP Analytics Cloud SAP Analytics Cloud, data modeling 

[William_Yu · Accepted solution]

Hi satoko_nakayama, 

  Probably you should use advance formula with LINK keyword to move data cross models. 

Best regards, William

[satoko_nakayama · Accepted solution]

Hi @William_Yu,
Thank you very much for your quick reply.
Is it possible to deal with what I want to achieve by referring to the help below?

https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/812f4d02ac13401d990ce...
Example 05: Cross-Model Advanced aggregation based on attributes of dimensions from the linked model

[William_Yu · Accepted solution]

I believe so, you anyway need to try this out.