Syntax Error on or before

Post Reply
viswaraju
Regular Participant
Posts: 177
Joined: Thu Nov 05, 2009 8:45 am
OLAP Product: IBM COGNOS TM1
Version: 9.5
Excel Version: 2007

Syntax Error on or before

Post by viswaraju »

Line 43: Syntax Error on or before;
!roles, !Budget version,
invalid string expression
Rule could not be attached to the cube ,but changes are saved.
This was the error i am getting.
User avatar
Michel Zijlema
Site Admin
Posts: 713
Joined: Wed May 14, 2008 5:22 am
OLAP Product: TM1, PALO
Version: both 2.5 and higher
Excel Version: 2003-2007-2010
Location: Netherlands
Contact:

Re: Syntax Error on or before

Post by Michel Zijlema »

viswaraju wrote:Line 43: Syntax Error on or before;
!roles, !Budget version,
invalid string expression
Rule could not be attached to the cube ,but changes are saved.
This was the error i am getting.
I assume you have a question on this. If so, perhaps it's a good idea to share some more information, f.i. the complete rule that the error applies to.

Michel
User avatar
rkaif
Community Contributor
Posts: 328
Joined: Fri Sep 05, 2008 6:58 pm
OLAP Product: IBM Cognos TM1
Version: 9.1 or later
Excel Version: 2003 or later

Re: Syntax Error on or before

Post by rkaif »

viswaraju wrote:Line 43: Syntax Error on or before;
!roles, !Budget version,
invalid string expression
Rule could not be attached to the cube ,but changes are saved.
This was the error i am getting.
With the error messages generated by Rules Editor, I have noticed that most of the time Line # mentioned is not exactly correct (specially when your rule spans to multiple lines). Therefore we have to look at the complete Rules to debug the errors.

As stated by Michel, you will have to post the complete Rule.
Cheers!
Rizwan Kaif
Wim Gielis
MVP
Posts: 3241
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Syntax Error on or before

Post by Wim Gielis »

rkaif wrote:With the error messages generated by Rules Editor, I have noticed that most of the time Line # mentioned is not exactly correct (specially when your rule spans to multiple lines). Therefore we have to look at the complete Rules to debug the errors.
This is particularly true when you forget the semicolon at the end of a line: the line number stated will generally be the next line number after the offending line.

But the message box states that a semicolon is missing so that should be easy to verify.
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Alan Kirk
Site Admin
Posts: 6667
Joined: Sun May 11, 2008 2:30 am
OLAP Product: TM1
Version: PA2.0.9.18 Classic NO PAW!
Excel Version: 2013 and Office 365
Location: Sydney, Australia
Contact:

Re: Syntax Error on or before

Post by Alan Kirk »

Wim Gielis wrote:
rkaif wrote:With the error messages generated by Rules Editor, I have noticed that most of the time Line # mentioned is not exactly correct (specially when your rule spans to multiple lines). Therefore we have to look at the complete Rules to debug the errors.
This is particularly true when you forget the semicolon at the end of a line: the line number stated will generally be the next line number after the offending line.

But the message box states that a semicolon is missing so that should be easy to verify.
Not always; I got one just yesterday where I copied a block, just missing the semi-colon, and the error message that I got on compile was that an equals sign was missing. The level of trust that you can put in TI error messages may be higher than zero, but not by much.
"To them, equipment failure is terrifying. To me, it’s 'Tuesday.' "
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
viswaraju
Regular Participant
Posts: 177
Joined: Thu Nov 05, 2009 8:45 am
OLAP Product: IBM COGNOS TM1
Version: 9.5
Excel Version: 2007

Re: Syntax Error on or before

Post by viswaraju »

not like missing semi colon, here it was in feeding cube it has one more dimension than the rule written cube. I can not able to feed the extra dimension,please any suggestions for me.

Thanks and reagrds.
Wim Gielis
MVP
Posts: 3241
Joined: Mon Dec 29, 2008 6:26 pm
OLAP Product: TM1, Jedox
Version: PAL 2.1.5
Excel Version: Microsoft 365
Location: Brussels, Belgium
Contact:

Re: Syntax Error on or before

Post by Wim Gielis »

viswaraju wrote:not like missing semi colon, here it was in feeding cube it has one more dimension than the rule written cube. I can not able to feed the extra dimension,please any suggestions for me.

Thanks and reagrds.
What element in that extra dimension contains the rules-calculated values? Feed to that particular element (when it comes to that dimension).
Best regards,

Wim Gielis

IBM Champion 2024-2025
Excel Most Valuable Professional, 2011-2014
https://www.wimgielis.com ==> 121 TM1 articles and a lot of custom code
Newest blog article: Deleting elements quickly
Post Reply