Concatenation in Rules

Post Reply
anoops81
Posts: 101
Joined: Tue May 12, 2009 8:20 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: Office 2010

Concatenation in Rules

Post by anoops81 »

Hi All ,

I wanted to know whether it is possible to concatenate string elements in rules statement.

I wanted to implement a measure element which evaluates to

Code: Select all

['Low Index']=['Material']|STR([' Index']);
Here Low Index , Material are string elements and Index is numeric .

I encountered an error "Syntax error on or before STR(['Index']); Missing semicolon

Any other suggestions to implement this will be helpful .

Regards
Anoop
User avatar
Steve Rowe
Site Admin
Posts: 2410
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: TM1 v6,v7,v8,v9,v10,v11+PAW
Excel Version: Nearly all of them

Re: Concatenation in Rules

Post by Steve Rowe »

Hi, when referencing strings in rules you need to use the full DB( ....) expression.
You also need the S qualifier
Also I'm not sure that you don't have all the arguments of the STR function in place, it's actually like this STR(number, length, decimal)

['Low Index']= S: DB ('cube' , etc, 'Material') | trim( STR([' Index'], 10 ,0)));

Should give you something like you are after.

Cheers
Technical Director
www.infocat.co.uk
anoops81
Posts: 101
Joined: Tue May 12, 2009 8:20 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: Office 2010

Re: Concatenation in Rules

Post by anoops81 »

Hi Steve ,

Thanks So much . It is working fine .
Post Reply