SAP Analytics Cloud - Get Value by Data Action

[guenay]

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?

@N1kh1l 

[MichalCK]

you need to put your 
DATA(Dim1=A1)=Resultlookup(Dim1=Holder, Dim2=#...)

into an IF statement to limit masterdata combinations

something like

IF RESULTLOOKUP() != NULL THEN

DATA(Dim1=A1)=Resultlookup(Dim1=Holder, Dim2=#...)

ENDIF

this will copy the value only to already existing combinations 

Best regards,

Michal

[guenay]

Alright I will try out.