I need to concatenate several properties of a dimension to store a value.
I'm in 7.0 SP06 MS, and I'm trying to do something like this:
* WHEN Dimension1
* IS ID1
* REC (Dimension1 = ID2, Dimension2 = Dimension2.Property1 + _ + Dimension2.Property2 + _ + Dimension2.Property3)
The Dimension 1 and Dimension2 are in scope, but when make concatenation only retrieves me the Property1 value, the other properties write them as literal.
Any idea is appreciated