cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Analytics Cloud - Get Value by Data Action

guenay
Participant
0 Kudos
380

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 1Dimension 2 Dimension 3 Dimension 4 Dimension 5 Amount (Measure)
      
Holder####150.000
A1B1C1D1E1 
A2B2C2D2E2 
A3B3C3D3E3 
A4B4C4D4E4 
      
      
Desired Outcome    
      
Dimension 1Dimension 2 Dimension 3 Dimension 4 Dimension 5 Amount (Measure)
      
Holder####150.000
A1B1C1D1E1150.000
A2B2C2D2E2150.000
A3B3C3D3E3150.000
A4B4C4D4E4150.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?

@N1kh1l 

View Entire Topic
thomas_beck
Advisor
Advisor
0 Kudos

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:

ans01.png

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":
ans02.png

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

guenay
Participant
0 Kudos
Thanks a lot. I will try it out and let you know about the results.