on 11-24-2010 3:20 PM
I created a Business Objects report that returns 239 results, and wanted to turn that around and input those results as the query filter for another report. However, when the report was run, it generated a Web Intelligence Server error message "A query filter object contains too many values for the object to be used in a query filter (Error: WIS 00019)". So, what exactly is the upper limit for values in a query object? I researched web help and all it tells me is to "select fewer values", but not how many satisfies the parameters...help!
This limit is basically determined by your RDBMS.
The resulting query will have in an IN LIST(value1, value2, value3...) for all values from your query.
The number of terms in the In List is limited, but the limit is different for each database and version.
When you are sure your RDBMS can handle more then you can use here,
have a talk with your universe designer. It is a parameter that can be raised.
If I'm not mistaken the standard limit is 128 distinct values.
Hope this helps,
Marianne
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
92 | |
11 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.