1477451 - Filter that uses a large number of In List paramgers produces error (WIS 10901) IES10901

• When using a large number of parameters for an In List filter the query runs for a short period of time and you are presented with an error;
• The error message :
  
  A database error occurred. The database error text is: [Microsoft SQL
  Native Client] : The query processor ran out of internal resources and
  could not produce a query plan. This is a rare event and only expected
  for extremely complex queries or queries that reference a very large
  number of tables or partitions. Please simplify the query. If you
  believe you have received this message in error, contact Customer
  Support Services for more information.. (WIS 10901)

• Business Objects Enterprise XI 3.1
• SAP BusinessObjects Business Intelligence Platform 4.X
• SQL server

This is a rare event and only expected for extremely complex queries or queries that reference a very large number of tables or partitions. Please simplify the query, webi, , KBA , BI-RA-WBI , Web Intelligence , Problem