Page 1 of 1
Contact String In TM1
Posted: Sun Dec 19, 2010 2:52 pm
by keigo840413
Hi All,
Simple question, how to contact string in the TM1 when writing cube's rule?
Re: Contact String In TM1
Posted: Sun Dec 19, 2010 5:22 pm
by Michel Zijlema
Hi,
Rules returning string values need to be prefixed with "S:", so:
[string-area] = S: formula;
Michel
Re: Contact String In TM1
Posted: Sun Dec 19, 2010 6:50 pm
by Alan Kirk
keigo840413 wrote: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:
will yield 'abcdef'.
Re: Contact String In TM1
Posted: Mon Dec 20, 2010 4:18 am
by keigo840413
thanks alan, this is exactly what i want..