Print Page - How many items can a filter hold?

Title: How many items can a filter hold?
Post by: Gloves on 04 Apr 2007 12:54:08 PM

I'm trying to filter on 3,700 customers and the filter is validating, but the report does not run. Is this too many customers? Is there a max? Any help would be greatly appreciated! ;D

Title: Re: How many items can a filter hold?
Post by: Darek on 04 Apr 2007 05:52:33 PM

The filter would be rather on the DB side I think. Is it a simple IN filter?

Title: Re: How many items can a filter hold?
Post by: Gloves on 05 Apr 2007 10:32:31 AM

I do not have access to the DB so I was just utilizing a filter in a query for this task. Yes, I use an IN statement for this action. [Customer #] IN (111111, 222222, 333333) and etc..

Title: Re: How many items can a filter hold?
Post by: COGNOiSe administrator on 05 Apr 2007 10:55:38 AM

Some databases have a limit on the length of the SQL statement and in your example 3700 customers with a 10 byte length of the filed would generate a 37kB+ SQL statement.

Title: Re: How many items can a filter hold?
Post by: Gloves on 05 Apr 2007 01:55:06 PM

Can my DBA adjust the SQL statement limit?

Title: Re: How many items can a filter hold?
Post by: COGNOiSe administrator on 05 Apr 2007 06:18:01 PM

Not sure, check with them.

COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: Gloves on 04 Apr 2007 12:54:08 PM