How to increase drop down values in BI-publisher parameter/prompt

Question

Hi Team,

I want to increase the drop down values in BI-Publisher parameters,

By default we are getting only 1000 values, but our requirement to  get upto 2000+ values.

please suggest is there any config file that we need to update to get a more then 2000+ values in BI-Publisher parameters.

Thanks,

Avin

Thomas Dodds · Answer

It's not a requirement - it's a wish.  It's a wish that comes when no one is vetting the capabilities of the system being used.

How many discreet values can you put in an IN clause in SQL?

Oracle chokes:  ORA-01795: maximum number of expressions in a list is 1000

So ... why would you allow users to possible select even 1001 values (which will get sent in the SQL as an IN clause with too many values)?

Looks like you need a different look at it ... I don't have any details from you to make any other suggestions.