on 2024 Apr 15 4:25 AM
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
Hi satoko_nakayama,
Probably you should use advance formula with LINK keyword to move data cross models.
Best regards, William
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
68 | |
9 | |
8 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.