Concatenate 2 properties

[monica_marquez2]

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

[JohnL]

What version are you using?

Have you tried:

*REC(factor=1, IndicadorF="ind_a2", Marca=Marca.Marca + _ + Marca.Canal)

If that doesn't work, why don't you create a new property in the member sheet and concatenate (using Excel functions) the Marca/Canal properties and then reference the new property in the logic?

Make sure your properties (new and old) are not checked off as "INAPP". Unless you use the properties in MDX calculations and statements.

Thanks,

John