Hi,
In Enter or Select box , i am selecting more than 100 customer ids from the list of values. It says that ‘too many values selected’. Did anybody meet this problem?. Is it possible to increase the limit. Please give me any suggestions. I will be glad.
Ravi.
______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com
Listserv Archives (BOB member since 2002-06-25)
Ravi - I’ve also encountered this limitation. BusObjects support confirmed that the limit is 99. They didn’t have a work-around but added it to their enhancement list.
George Baranowski/QuadraMed
Hi,
In Enter or Select box , i am selecting more than 100 customer ids from the list of values. It says that ‘too many values selected’. Did anybody meet this problem?. Is it possible to increase the limit. Please give me any suggestions. I will be glad. Ravi.
Listserv Archives (BOB member since 2002-06-25)
In a message dated 98-11-10 16:25:37 EST, you write:
<< i am selecting more than 100 customer ids from
the list of values. It says that ‘too many values selected’. >>
I believe that the number of values you can choose is limited by the database you are querying against. In Oracle, you can choose up to 255 values for your list. In other databases, it is much lower. Unfortunately, these limits cannot be changed - they are part of the rules for that database.
You might try the following alternative. You can create a subquery that provides a list of customers that will satisfy your original condition. Inside the operand of your original condition, click on ‘Create a subquery’. This will open a second Query Panel where you can create a second query that provides the list of customers. Just make sure that the second query returns just one result object - in your case, the Customer ID.
Another idea: Do the customers you are trying to place in your condition have anything in common ? Are they in the same sales region or territory ? Are they tied to the same sales representative ? If so, restrict the region, territory, or sales rep.
Regards,
Alan Mayer
amayer@islink.com
Integra Solutions, Inc.
Listserv Archives (BOB member since 2002-06-25)
Ravi,
If you are using ORACLE, the number of LOVs you are allowed to select has changed from the 255 in BO 4.0.5.x to 99 in BO 4.1.x
This behaviour should be changing in the near future, but it was done to preserve ‘integrity’ between databases. Not all databases allowed 255 values for an inlist so they changed the product to meet the lowest common demoninator. A fix is in the works to allow this value to change dynamically with the Database type.
Your current workaround is to create a secondary prompt and OR them together. This will allow 99 values per prompt. You can also create a secondary report and merge them together, but this is easier.
Thanks!
-rm
Listserv Archives (BOB member since 2002-06-25)
Ravi,
We ran into this problem with some of our objects when they were displayed in the Tabular View in the List of Values window. By changing from the Tabular to the Hierarchical View we were able to select more than 99 values.
Mike
Listserv Archives (BOB member since 2002-06-25)