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.
Syntax Error on or before
- 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
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.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.
Michel
- 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
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.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.
As stated by Michel, you will have to post the complete Rule.
Cheers!
Rizwan Kaif
Rizwan Kaif
-
- 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
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.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.
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
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
-
- 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
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.Wim Gielis wrote: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.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.
But the message box states that a semicolon is missing so that should be easy to verify.
"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.
-----------
Before posting, please check the documentation, the FAQ, the Search function and FOR THE LOVE OF GLUB the Request Guidelines.
-
- 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
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.
Thanks and reagrds.
-
- 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
What element in that extra dimension contains the rules-calculated values? Feed to that particular element (when it comes to that dimension).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.
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
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