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

help w/ filter in report studio

Started by karthik.cognos, 11 Feb 2013 01:51:35 PM

Previous topic - Next topic

karthik.cognos

Hi,
I'm trying to create a filter in Report Studio with some conditions using a bunch of AND's & OR's, but the query that is being sent to the Teradata database or the query that is being genereated in report is not grouping the conditions the way I need. Could someone shed some light?

Here is the filter that I would like to build:
(I'll use 'C' for each condition that I have in my filter expression):

(C1 AND C2)
OR
(C3 AND C4)
OR
(C5 AND C6)

But when I see the where clause in the query that Cognos is generating, I see this:

(C1
AND C2
OR C3
AND C4
OR C5
AND C6)

Can someone please help?

Thank you in Advance!

pricter

Have you tried to put the conditions into brakets?
For example
((C1) AND (C2))
OR
((C3) AND (C4))
OR
((C5) AND (C6))

karthik.cognos

I tried your suggestion, but no luck.
Any other ideas?