Hi all!
I wonder if there is any way to store data in a combination of properties (of a dimension).
For Example:
Marca Dimension:
Properties
ID...................Marca............Canal............Tipo
cli_01................mkt_1..........chn_21.........cliente
cli_02................mkt_1..........chn_11.........cliente
cli_03................mkt_2..........chn_01.........cliente
etc
I have to do a calculation and store it in the Marca Mercado combination.
So,
*SELECT (%cli%,ID,MARCA,Tipo='cliente') *WHEN Marca *IS %cli% *WHEN IndicadorF *IS ind_a1 *REC(factor=1, IndicadorF="ind_a2", Marca= ??) // I need to store data like Marca=mkt_1_chn_21 *ENDWHEN *ENWHEN
When ID is cli_01 i need to store data in mkt_1_chn_21 and so on.
If I write this:
*REC(factor=1, IndicadorF="ind_a2", Marca=Marca.Marca) //Marca=mkt_1
I've managed to save the data in a property but cannot get it in two at a time
Any idea how?
Thanx in advance