copy data between models based on dimension properties 1:M

[ypinchuk]

Hello,

I'm working on the app for project planning. Business requirements: there should be a set of general Project Templates, which are used then for creating new planned projects. So the relation type between Template and Budget is 1:M

So, I have two models: Template and Budget, which differ in two dimensions highlighted in blue

Dimensions Group and Task have properties, containing IDs of their templates - T_Group and T_Task respectively.

I need to copy data from Template model to Budget model, so the data should be copied from T_Group dimension to the Group dimension which TemplateGroupId property = T_Group.

So first I have to find the member of Group dimension with the required property and then copy data (Advanced Formulas)

Please advise how can I do the task above (in bold italic)

Thank you!

[N1kh1l · Accepted solution]

yuripinchuk

yuripinchukYou could try the LINK function in Advanced formula. I am assuming you will copy from Template to Budget and the attributes will maintained on Budget side pointing to Template model. Some rough syntax like below

MODEL [Template]
ENDMODEL
DATA()=LINK([Template] ,[d/T_Group]=[d/Group].[p/T_Group], [d/Version]="public.Actual" )

A similar question has been answered here

https://answers.sap.com/questions/13962738/sap-sac-dataaction-dimension-member-property-read.html?ch...

Br.

Nikhil

[ypinchuk · Accepted solution]

Nikhil

Many thanks!