If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

QE-DEF-0030 Expression parsing in cognos 10.2

Started by 84gopi, 16 Sep 2015 09:55:12 AM

Previous topic - Next topic

84gopi

Hi,

I am using overriding SQL in my report studio and does not any filter or anything in the report.

When I run the report i am getting below error

QE-DEF-0030 Expression parsing.

Can you please advise ASAP.

Thanks
Gopi

BigChris

The problem is that you got something wrong in your SQL.

Michael75

The second problem is that you shouldn't really be using SQL in your report.

bdbits

Actually, that's backwards. The first problem is using SQL in the report.   ;D

Was there a reason you used SQL? Is there something you did not know how to do with a package? I have found very, very few reasons to drop down to coding SQL for Cognos, and even then I normally encapsulate it into a database view and use that as a query subject in FM. Perhaps we can solve your original problem and skip the SQL altogether.

The error is generic but means the SQL was not seen as valid SQL. Copy and paste it into your native database query tool and see if that provides more information. If you insist on using the SQL and want help with that, you'll need to specify what database and version you are using. Then post the SQL here and hope someone can see the error.

cognostechie

The third problem is that you are not trying to understand what's going in the report and simply posting it here hoping somebody would magically help you out  ;D

BigChris

I think magically is the operative word there - take a look at point 1 in the forum etiquette and I think you'll see that it pretty much describes your question...