PA Case Sensitive vs. TM1 10.2 not case sensitive

Post Reply
jcr55
Posts: 48
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 » Thu Nov 01, 2018 2:30 pm

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: 1818
Joined: Wed May 14, 2008 4:25 pm
OLAP Product: TM1
Version: 10.2.2., PAW
Excel Version: Nearly all of them

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

Post by Steve Rowe » Thu Nov 01, 2018 3:27 pm

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.

User avatar
tomok
MVP
Posts: 2491
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 » 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.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/

User avatar
jim wood
Site Admin
Posts: 3609
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

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

Post by jim wood » Thu Nov 01, 2018 4:49 pm

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

jcr55
Posts: 48
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 » Thu Nov 01, 2018 5:01 pm

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: 3138
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 » 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.
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.

User avatar
jim wood
Site Admin
Posts: 3609
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

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

Post by jim wood » Thu Nov 01, 2018 7:22 pm

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.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

Post Reply