How to derive the master data values from existing transactional data using data action?

[azm_azm]

Hi, 

Here is the scenario,

There are four dimension as Factory, Location, Type, Account in the model.

Factory	Location	Type	Account	Value
A	Seattle	#	Sales Qty	150
A	Seattle	X	Price	10
B	California	#	Sales Qty	95
B	California	Y	Price	7

I want to write a data action logic which checks if factory is "A" and location is "Seattle" then it should derive the values as "X" type for Sales Qty account based on transactional data dimension combination of Price row and similarly if factory is "B" and location is "California" then it should derive the values as "Y" type for Sales Qty account based on transactional data dimension combination of Price row.

In short, I want to derive the values of master data based on existing transactional data in the model using data actions.

Anyone who has faced similar kind of issue or knows the workaround in this scenario. Their comments would be deeply appreciated.

Thanks.

[Savio_Dmello]

Try this. pls check all the syntax .

IF ([d/Factory] = "A" AND [d/Location] = "Seattle") THEN
DATA([d/Type] = "#", [d/Account] = "Sales Qty") = RESULTLOOKUP([d/Type] = "X", [d/Account] = "Price");
ENDIF

IF ([d/Factory] = "B" AND [d/Location] = "California") THEN
DATA([d/Type] = "#", [d/Account] = "Sales Qty") = RESULTLOOKUP([d/Type] = "Y", [d/Account] = "Price");
ENDIF