Skip to Content
0
Sep 19, 2023 at 02:43 PM

copy data between models based on dimension properties 1:M

99 Views Last edit Sep 19, 2023 at 04:18 PM 2 rev

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

image.png

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!

Attachments

image.png (3.4 kB)