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.