on 2024 Jul 25 2:00 PM
Hi friends,
I have a scenario where I have a dummy data row called "Holder," and I want to copy its values to valid data rows. Please see the table below:
Current State | |||||
Dimension 1 | Dimension 2 | Dimension 3 | Dimension 4 | Dimension 5 | Amount (Measure) |
Holder | # | # | # | # | 150.000 |
A1 | B1 | C1 | D1 | E1 | |
A2 | B2 | C2 | D2 | E2 | |
A3 | B3 | C3 | D3 | E3 | |
A4 | B4 | C4 | D4 | E4 | |
Desired Outcome | |||||
Dimension 1 | Dimension 2 | Dimension 3 | Dimension 4 | Dimension 5 | Amount (Measure) |
Holder | # | # | # | # | 150.000 |
A1 | B1 | C1 | D1 | E1 | 150.000 |
A2 | B2 | C2 | D2 | E2 | 150.000 |
A3 | B3 | C3 | D3 | E3 | 150.000 |
A4 | B4 | C4 | D4 | E4 | 150.000 |
I've tried various data action coding techniques but haven't achieved the desired outcome. When I use DATA(Dim1=A1)=Resultlookup(Dim1=Holder, Dim2=#), it generates a dataset for every available master data entry. On the other hand, using FOREACH.Booked doesn't work either, as the master data is used in other data rows as well and therefore generates again unvalid data rows
Does anyone have any suggestions?
Hi @guenay,
As already indicated this does work with Advanced Formulas (the scripting part in Data Actions) and setting the proper scope to avoid booking to all member combinations. Depending on your use case (and flexibility needed), you can also leverage the Cross-Model Copy Step by using the same source and taget model as shown below:
As it is the same source and target model, all dimensions are mapped to their identical counter parts. The magic is then in the individual copy rules (select the individual dimension members in the screenshot above) - here for dimension "A":
Here are the details:
* By selecting Auto-Generation Strategy "No Auto-Creation" you can create manual mappings according to your valid combinations (e.g. from # to A1 .. A4)
* By selecting Completion Strategy "Do not copy remaining members" all missing rules are ignored and only the scope configured will be copied
* Now create an individual copy rule to transfer data from your Holder member to your valid combination
Once repeated for all relevant dimensions you should be all set. As configuration is in the copy rules, this is a rather static approach - you could combine with the newly introduced Auto-Generation Strategy based on dimension properties to manage via master data - coming QRC3.2024.
Hope this is an alternate solution to your problem!
Regards,
Thomas
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
62 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.