cancel
Showing results for 
Search instead for 
Did you mean: 

Maximum number of values ​​in a filter

Former Member
0 Kudos

Hi Dears,

I would like to know what is the maximum number of values ​​that I can enter a filter in SAP BO Webi.

10, 1000 or a million do not know.

Please help.

Best regards.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Andres,

The default value for MAX_INLIST_VALUES is -1. With this, there will not be any limitation from BO end. The limitation (if any) would be from the database in case you are passing within IN operator as below:

table1.column1 IN (value1, value2, value3,.....,value n)

For example, Oracle will allow only 1000 values with IN operator.

In your case, this limitation should not come into picture. Try with a value as -1 and check.

Regards,

Yuvraj

Former Member
0 Kudos

Hi Yuvraj,

Thanks you for you answer.

The parameter in the universe "Limit size of long text objects to"

affect this list or not and why.

Thank you.

Best regards.

Former Member
0 Kudos

Hi Andres,

This option should affect the size of the object and not the number of values coming in IN LIST.

Try MAX_INLIST_VALUES = -1, it should help you.

Regards,

Yuvraj

Answers (1)

Answers (1)

kohesco
Active Contributor
0 Kudos

Hi,

Web Intelligence Processing Server-> Maximum List Of Values Size (entries) - 50000 (default)

As entry I believe default is set to 999 (MAX_INLIST_VALUES - default is 999) should be sufficient