I successfully customized the list of values for one of my objects in version 4.1.2. I imported an excel spreadsheet containing approx. 250 records. Everything seemed to be fine.
When I do a condition on that object and select all 250 records and hit Ok, I get the message ‘To many selected values’. It appears to give me that message if I select over 100 records.
Does anyone know how to raise this threshold, if possible.
I have seen this issue pop up couple of times. We have users using upto 335 values in the in list clause. If Business Objects does not allows more then 100 values the other option wil be: 1) Either to create a sub query.
2) Type in the values in the query panel with the IN LIST operator.
As I mentioned we have users who use upto 335 (our backend database is ORACLE) and it works fine. You might need to tune the query to make it run since the optimizer will go craze with such a huge in list Dilip
I encounter this very frequently. The threshold is not configurable. I believe BusObjects is considering a fix that would make the threshold database-dependent.
George Baranowski
QuadraMed
… When I do a condition on that object and select all 250 records
and
hit Ok, I get the message ‘To many selected values’. It appears to give me that message if I select over 100 records.
Does anyone know how to raise this threshold, if possible.
Dilip