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
Rule Error
-
- 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
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.
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.
-
- Posts: 19
- Joined: Mon Jul 16, 2012 11:50 am
- OLAP Product: TM1
- Version: 9.5.2
- Excel Version: 2007
Re: Rule Error
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
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
-
- 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
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.
Would you mind posting the nature of the small error? It's potentially interesting for others in case it turns up again.
-
- MVP
- Posts: 733
- Joined: Wed May 14, 2008 11:06 pm
Re: Rule Error
I just experienced this moving from 9.5.1 to 9.5.2 so perhaps that's where the change occurred.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?
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: ...
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: ...
Robin Mackenzie
-
- 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
Also encountered exactly this when upgrading from 9.5.1 to 9.5.2.rmackenzie wrote:I just experienced this moving from 9.5.1 to 9.5.2 so perhaps that's where the change occurred.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?
E.g. this worked in 9.5.1 but not in 9.5.2:Note that the two measures aren't parenthesised with {...}Code: Select all
['dim1_elem', 'dim2_elem', 'dim3_elem', 'measure1', 'measure2'] = N: ...
So, when we upgraded to 9.5.2 and restarted the instance, this rule file wouldn't compile and needed to be changed to:I was a bit surprised that this was possible!Code: Select all
['dim1_elem', 'dim2_elem', 'dim3_elem', {'measure1', 'measure2'}] = N: ...
-
- 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
... 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
Holger