Valuing dimensions with members # using already available rows

[andreag412]

Dear experts,
I would need some help with the development of a Data Action.
After a first step of Cross-Model Copy the row situation is as follows:

View	Entity	Market	Products	Customer	Channel	Sales Category	Intercompany	Distr. Flow	Net Sales (Local)	Std Cost EoL (Local)	Std Cost Mark Up Reverse (Local)
#	V10	VN	Prod1	DEALER	RET	COMMON	#	STOCK	10000	–	–
#	V10	#	Prod1	#	#	#	#	#	–	500	0

I have taken 2 rows as an example, the purpose would be to go and “merge” the two rows. So with end result the following:

View	Entity	Market	Products	Customer	Channel	Sales Category	Intercompany	Distr. Flow	Net Sales (Local)	Std Cost EoL (Local)	Std Cost Mark Up Reverse (Local)
#	V10	VN	Prod1	DEALER	RET	COMMON	#	STOCK	10000	500	0

Do you have any advice on how this can be done?

Thanks for the help

[andreag412]

HI @MichalCK,

Thanks for the help, I have implemented this logic:

VARIABLEMEMBER #Customer OF [d/Customer]
VARIABLEMEMBER #Channel OF [d/Channel]
VARIABLEMEMBER #Scat OF [d/SalesCateg]
VARIABLEMEMBER #Market OF [d/Market]
VARIABLEMEMBER #DF OF [d/DistributionFlow]

DATA([d/Customer] = #Customer,
	 [d/Channel] = #Channel,
	 [d/SalesCateg] = #Scat,
	 [d/DistributionFlow] = #DF,
	 [d/Market] = #Market) = RESULTLOOKUP()

IF RESULTLOOKUP([d/Measures] = "NET_SALES_LOCAL") != NULL THEN
	DATA([d/Measures] = "STD_COST_EOL_LOCAL") = RESULTLOOKUP([d/Customer] = #Customer,
															 [d/Channel] = #Channel,
															 [d/SalesCateg] = #Scat,
															 [d/DistributionFlow] = #DF,
															 [d/Market] = #Market,
															 [d/Measures] = "STD_COST_EOL_LOCAL")
	DATA([d/Measures] = "STD_COST_MKUP_REV_LOCAL") = RESULTLOOKUP([d/Customer] = #Customer,
																  [d/Channel] = #Channel,
																  [d/SalesCateg] = #Scat,
																  [d/DistributionFlow] = #DF,
																  [d/Market] = #Market,
																  [d/Measures] = "STD_COST_MKUP_REV_LOCAL")
ENDIF

But we don't get the desired result, because the table shows:

View	Entity	Market	Products	Customer	Channel	Sales Category	Intercompany	Distr. Flow	Net Sales (Local)	Std Cost EoL (Local)	Std Cost Mark Up Reverse (Local)
#	V10	VN	Prod1	DEALER	RET	COMMON	#	STOCK	10000	–	–
#	V10	#	Prod1	#	#	#	#	#	500	500	500