Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

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

Received Response
1
Views
1
Comments
3051139
3051139 Rank 3 - Community Apprentice
edited Aug 13, 2024 5:38PM in Oracle Analytics Forum

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

Answers

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics & AI Strategist

    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.