STET Problem when element name starts with number

Post bug reports and the status of reported bugs
Post Reply
Posts: 2832
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

STET Problem when element name starts with number

Post by tomok »

I just ran across this issue today. I wanted to create a rule to apply to all the elements in a dimension, in this case Version, and then just STET it out at the top for the "Actual" version (we have multiple forecasts). So the STET rule initially looked like this:

Code: Select all

[] = N:IF(ELISCOMP('TAX - NT - Version', !TAX - NT - Version, 'Frozen Versions') = 1, STET, CONTINUE);
I had one child under this parent called "2015 Q3 Forecast". The STET would not work. All the rules underneath continued to apply even though "2015 Q3 Forecast" was a child of "Frozen Versions". So, I decided to skip the ELISCOMP and do this:

Code: Select all

['2015 Q3 Forecast'] = N:STET;
This didn't work either which is a no brainer that it should. So, I added another element as a child of "Frozen Versions" called "Q3 2015 Forecast", the key here being the element name does not start with a number. Voila!, it worked.

Has anyone else seen this before?

Version 10.2.2
Fix Pack 3

PS. This only happened on one server. Another server does not have a problem. Both are running the same version of TM1.
Tom O'Kelley - Manager Finance Systems
American Tower
User avatar
Steve Rowe
Site Admin
Posts: 2421
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: STET Problem when element name starts with number

Post by Steve Rowe »

Since it doesn't _appear_ to be a version related bug, maybe the element is reserved or locked and that is confusing the situation?

Is the behaviour preserved through a restart?
Technical Director
Post Reply