TM1 Forum

Posted: **Tue May 13, 2014 9:39 am**

Hi all,

I have a cube made up by 4 dimensions and 4 string measures.
A measure might be calculated (by a rule) concataining the other 3 measure and the dimension values as follows (it's an example):

: TM1_example.png (2.38 KiB) Viewed 2423 times

M1, M2 and M3 can be cancatenated using :
['M4'] = ['M1'] | ['M2'] | ['M3'];
How can I reference the dimension values in the above formula?
Thank you so much for your time.

Posted: **Tue May 13, 2014 9:51 am**

Rosanero4Ever wrote: M1, M2 and M3 can be cancatenated using :
['M4'] = ['M1'] | ['M2'] | ['M3'];
How can I reference the dimension values in the above formula?
Thank you so much for your time.

You can reference the dimension elements by using the ! bang symbol but your measure references will also need to be changed as the square bracket shorthand doesn't work for strings.

Code: Select all


['Measure 4'] =S: !Dim1 | !Dim2 | !Dim3 | !Dim4 | DB ( 'Cube', !Dim1 , !Dim2, !Dim3, !Dim4, 'Measure 1' ) | DB ( 'Cube', !Dim1 , !Dim2, !Dim3, !Dim4, 'Measure 2' ) | DB ( 'Cube', !Dim1 , !Dim2, !Dim3, !Dim4, 'Measure 3' );

TM1 Forum

Concatenate dimension value in a cube measure

Concatenate dimension value in a cube measure

Re: Concatenate dimension value in a cube measure