Rule Error

Post Reply
pablo
Posts: 19
Joined: Mon Jul 16, 2012 11:50 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007

Rule Error

Post by pablo »

Hi,

Client upgraded from TM1 9.5.2 to Express 10.1

Now I get this error when opening a specific rux file: Dimension "TB Account" is referenced more than once.

If I start the model in TM 1 9.5.2 the error is gone. I have done some reading on the forum and it has something to do with the tm1s.lin (language) file that can be corrupt. Can anyone just guide me in the right direction please.

Should or can I replace the tm1s.lin file?

Thank You in advance
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: Rule Error

Post by Duncan P »

It is not to do with the language file. What has happened is that your search of the forum for the error message has exposed a post in which a complete list of the error message text was included in a response.

What you are seeing is probably a result of a tightening of the rule syntax checking that happened sometime between 9.4.1 and 9.5.2. What exact version of 9.5.2 does this rule work in?

If it is what I suspect then within a [ ... ], either on the left or the right of the = two or more items from the same dimensions are referenced without being enclosed in { ... } as described in the syntax documentation here http://publib.boulder.ibm.com/infocente ... rea_N70150.
pablo
Posts: 19
Joined: Mon Jul 16, 2012 11:50 am
OLAP Product: TM1
Version: 9.5.2
Excel Version: 2007

Re: Rule Error

Post by pablo »

Duncan,

Thank you for the reply

My rule was not correct(missed something small), but for some reason 9.5.2 FP 2 didn't mind the error and everything worked. Weird!!

But in Express 10 and TM1 10 I get the error. And there should be an error.

It is fixed now.


Thank you
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: Rule Error

Post by Duncan P »

Glad it's fixed now.

Would you mind posting the nature of the small error? It's potentially interesting for others in case it turns up again.
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Rule Error

Post by rmackenzie »

Duncan P wrote:What you are seeing is probably a result of a tightening of the rule syntax checking that happened sometime between 9.4.1 and 9.5.2. What exact version of 9.5.2 does this rule work in?
I just experienced this moving from 9.5.1 to 9.5.2 so perhaps that's where the change occurred.

E.g. this worked in 9.5.1 but not in 9.5.2:

Code: Select all

['dim1_elem', 'dim2_elem', 'dim3_elem', 'measure1', 'measure2'] = N: ...
Note that the two measures aren't parenthesised with {...}

So, when we upgraded to 9.5.2 and restarted the instance, this rule file wouldn't compile and needed to be changed to:

Code: Select all

['dim1_elem', 'dim2_elem', 'dim3_elem', {'measure1', 'measure2'}] = N: ...
I was a bit surprised that this was possible!
Robin Mackenzie
lotsaram
MVP
Posts: 3704
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Rule Error

Post by lotsaram »

rmackenzie wrote:
Duncan P wrote:What you are seeing is probably a result of a tightening of the rule syntax checking that happened sometime between 9.4.1 and 9.5.2. What exact version of 9.5.2 does this rule work in?
I just experienced this moving from 9.5.1 to 9.5.2 so perhaps that's where the change occurred.

E.g. this worked in 9.5.1 but not in 9.5.2:

Code: Select all

['dim1_elem', 'dim2_elem', 'dim3_elem', 'measure1', 'measure2'] = N: ...
Note that the two measures aren't parenthesised with {...}

So, when we upgraded to 9.5.2 and restarted the instance, this rule file wouldn't compile and needed to be changed to:

Code: Select all

['dim1_elem', 'dim2_elem', 'dim3_elem', {'measure1', 'measure2'}] = N: ...
I was a bit surprised that this was possible!
Also encountered exactly this when upgrading from 9.5.1 to 9.5.2.
holger_b
Posts: 131
Joined: Tue May 17, 2011 10:04 am
OLAP Product: TM1
Version: Planning Analytics 2.0
Excel Version: 2016
Location: Freiburg, Germany

Re: Rule Error

Post by holger_b »

... this also solves the server log error message "element <element> is from dimension <dimension> and an element from this dimension previously appears". Thank you for reporting this, you saved my day!

Holger
Post Reply