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

Filter and parsing error

Started by barrysaab, 19 Sep 2011 12:37:50 PM

Previous topic - Next topic

barrysaab

In my report, which is developed through SQL, I have several category codes of different categories. It is concatenated column for which I have taken a data item and concatenated category code and desc. I want to restrict it to some categories code to only few but filter is throwing up an error "sql prepare with" and parsing error. I gave expression like [data item] not in ('1','2',3'). Please Help.

Boy! Cognos getting on to me!!!

kalyanapu

You are concatenating the Code and Description but you are including the code in not in function. How it recognizes the Data Code only when it has description.
Use the Concertinaed Field value or Create one data item for code only and use that one in Filter area.

One More thing for report performance wise better to avoid the "Not in" operator when you are dealing with huge amount of data"
Check with your business scenario.

Best Regards,
Srinivas Kalyanapu