Skip to Content
0
Oct 19, 2011 at 05:01 PM

Concatenate 2 properties

30 Views

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