Experts: How to disable maximum rows 500 for drop down boxes

[Former Member]

Hi experts,

I am using multiple drop down boxes that have dynamic entry lists and influence each other. Lets say:

- Division

- Product (determined by Division)

- Customer (determined by Division and Product)

Now if my dashboard is start up the drop down box for customer only contains values between A... and K..... Customers that start with the letter L or higher are not shown. After choosing a division Customers starting with A... till P... are shown. After choosing a specific product all relevant Customers are shown.

What happens is that the drop down box looks at the output of the query that is underneed. If this query contains more than 500 rows only the first 500 rows are counted.

I would like to let the drop down box include all rows. How can I do this? For queries that are dragged to the storyboard it is possible to select the maximum rows. For queries that are used in a drop down box this is not possible.

Thanks in advance,

Ralph

[Former Member]

Hi Ralph,

check this Wiki entry:

[https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/savingchangesofquerysettingsfailed&|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/vc/savingchangesofquerysettingsfailed&]

I think it should be possible to modify the default setting of 500 records.

You also should think about the usability, a dropdown with more than 500 records is not good, maybe a value help is the better solution.

Best Regards,

Marcel

[Former Member]

can any body propose a solution for this. I am also facing the same issues and trying to overcome this.

-Aravind