PA Case Sensitive vs. TM1 10.2 not case sensitive

Post Reply
jcr55
Posts: 54
Joined: Tue May 08, 2012 3:58 pm
OLAP Product: TM1
Version: 9.5.2 FP2
Excel Version: Excel 2007

PA Case Sensitive vs. TM1 10.2 not case sensitive

Post by jcr55 »

Current TM1 version: 10.2.2 FP7

We are very close to starting the switch to IBM Planning Analytics Local 2.0.6.

I read somewhere that PA will treat upper and lower case as different values (i.e. it will be case sensitive), versus TM1 historically has been not case sensitive.

I inherited many (61, to be exact) TI processes where a Variable name has an upper case "I" in one command, and a lower case "i" in another command - example:

strWIld = '*.txt';
strName = 'FlashData' | strWild;

In TM1 10.2.2, the TI processes run correctly.
Will they have a problem in PA 2.0.6 thinking they are now two different variable names?
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: PA Case Sensitive vs. TM1 10.2 not case sensitive

Post by Steve Rowe »

Just double checked

a=2;
b=a*A;

compiles just fine (in old style TI editor)

but
a=2;
b=a*c;

does not so I don't believe there is an issue

The only place I have noticed case being issue is in the server name, not noticed an issue elsewhere, not even sure it is always an issue with the server name. Might have been a defect that existed for a while.
Technical Director
www.infocat.co.uk
tomok
MVP
Posts: 2831
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: PA Case Sensitive vs. TM1 10.2 not case sensitive

Post by tomok »

I think they mean PA is case sensitive for TM1 objects like cubes, dimensions, elements, attributes, etc. Not variable names inside a TI process.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: PA Case Sensitive vs. TM1 10.2 not case sensitive

Post by jim wood »

tomok wrote: Thu Nov 01, 2018 4:23 pm I think they mean PA is case sensitive for TM1 objects like cubes, dimensions, elements, attributes, etc. Not variable names inside a TI process.
Oh yah, copy and paste ahoy!!
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
jcr55
Posts: 54
Joined: Tue May 08, 2012 3:58 pm
OLAP Product: TM1
Version: 9.5.2 FP2
Excel Version: Excel 2007

Re: PA Case Sensitive vs. TM1 10.2 not case sensitive

Post by jcr55 »

tomok wrote: Thu Nov 01, 2018 4:23 pm I think they mean PA is case sensitive for TM1 objects like cubes, dimensions, elements, attributes, etc. Not variable names inside a TI process.
OK, great. Thank you to all who responded.
lotsaram
MVP
Posts: 3651
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: PA Case Sensitive vs. TM1 10.2 not case sensitive

Post by lotsaram »

If (more likely when) case sensitivity is introduced I think it is a very safe bet that this will be controlled by a tm1s.cfg parameter where the default value is set to false for backwards compatibility.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
User avatar
jim wood
Site Admin
Posts: 3951
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: PA Case Sensitive vs. TM1 10.2 not case sensitive

Post by jim wood »

lotsaram wrote: Thu Nov 01, 2018 5:50 pm If (more likely when) case sensitivity is introduced I think it is a very safe bet that this will be controlled by a tm1s.cfg parameter where the default value is set to false for backwards compatibility.
We all know how well these things have worked in the past......
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply