String 'A B' equal to 'AB'

Post Reply
bunchukokoy
Regular Participant
Posts: 197
Joined: Thu Dec 03, 2009 8:47 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2.x
Excel Version: 2010
Location: Singapore

String 'A B' equal to 'AB'

Post by bunchukokoy »

Hi guys,

It seems (no it really does. :) ) that TM1 treats 'A B' same as 'AB' and 'A B'.
And the other way around 'C D' to 'CD'

Even this --> 'ABC DEF' is equal to 'AB CD EF', to 'AB c d E f'

A little issue-maker. :)

Actually I noticed this before, years ago. It's just that my new client HAS data like these.
Anyone knows if there's anything they plan to do about it? Haha.

I didn't care about it though, until I encountered these data.

TM1 trims out all spaces. and still applies case insentivity.

(I put many spaces in the middles of my samples, but the canvas also trims to only 1)
User avatar
Michel Zijlema
Site Admin
Posts: 713
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: String 'A B' equal to 'AB'

Post by Michel Zijlema »

This is documented behaviour - see the Object Naming Conventions section (regarding Case Sensitivity and Spaces in Object Names).

Michel
Duncan P
MVP
Posts: 600
Joined: Wed Aug 17, 2011 1:19 pm
OLAP Product: TM1
Version: 9.5.2 10.1 10.2
Excel Version: 2003 2007
Location: York, UK

Re: String 'A B' equal to 'AB'

Post by Duncan P »

It is also covered in more depth in this post.
bunchukokoy
Regular Participant
Posts: 197
Joined: Thu Dec 03, 2009 8:47 am
OLAP Product: IBM Cognos TM1
Version: 10.2.2.x
Excel Version: 2010
Location: Singapore

Re: String 'A B' equal to 'AB'

Post by bunchukokoy »

Thanks for giving the links. :)
Post Reply