Contact String In TM1

[keigo840413]

Hi All,
Simple question, how to contact string in the TM1 when writing cube's rule?

[Michel Zijlema]

Hi,

Rules returning string values need to be prefixed with "S:", so:
[string-area] = S: formula;

Michel

[Alan Kirk]

Hi All,
Simple question, how to contact string in the TM1 when writing cube's rule?

I'm not completely clear what your question is; Michel may have answered it with the general syntax but if you meant to ask how to concatenate (join) strings you use the pipe operator:

Code: Select all

'abc' | 'def'

will yield 'abcdef'.

[keigo840413]

thanks alan, this is exactly what i want..