cancel
Showing results for 
Search instead for 
Did you mean: 

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

satoko_nakayama
Explorer
0 Kudos

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.

satoko_nakayama_0-1713150849160.png

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.

satoko_nakayama_1-1713151030936.png

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 

View Entire Topic
William_Yu
Product and Topic Expert
Product and Topic Expert

Hi satoko_nakayama

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

Best regards, William

satoko_nakayama
Explorer
0 Kudos

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
Product and Topic Expert
Product and Topic Expert
I believe so, you anyway need to try this out.