Bo4.2--error ORA-01795

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