Bo4.2--error ORA-01795

[azazeererer]

Hello,

I work with Sap Bo 4.2 Sp7.

I have two queries:

1- "SDT request" which returns 4400 lines/Id Resources

2- "DispoRess" request, in which I have the filter on Resource Id reported by the 1st SDT request.

When executing these Bo queries, I got the following error message:

"The following database error occurred: ORA-01795: the maximum number of expressions allowed in a list is 1000"

Is there a solution so that the 4400 resources uploaded from the 1st SDT request are all integrated into the filter of the 2nd "DispoRess" request?

Thanks in advance.

Regards

[mhmohammed]

Hi Meryem,

Please create a Subquery in the query "DispoRess" which has the all the filters which are in "Requete SDT"

Checkout the below forum questions:
https://answers.sap.com/questions/12409190/issue-with-inlist-operator-limitation.html?childToView=12...
https://answers.sap.com/questions/12713165/data-filter-issue.html?childToView=12714170
https://bukhantsov.org/2012/09/07/example-of-sub-query-in-webi/
Youtube video of how to create a subquery, https://bukhantsov.org/2012/09/07/example-of-sub-query-in-webi/

Thanks,
Mahboob Mohammed

[ayman_salem]

see KBA 2823467 - The error "ORA-01795: maximum number of expressions in a list is 1000" appears when refres...