Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

OBIEE - Subquery contains too many values for the IN predicate

3713479Jun 12 2019 — edited Jun 17 2019

Can anyone suggest a reason why this error only occurs when the report is run from within a Dashboard ?

When run outside the Dashboard, no error is triggered.

The report filters are based on prior reports. The prior reports trigger filters on other reports which increase the total rows queried.

Online posts suggest increasing the MAX_EXPANDED_SUBQUERY_PREDICATES from 8K to a higher value such as 15 or 25K.

Thanks for any insights on this issue.

This post has been answered by 3713479 on Jun 13 2019

Jump to Answer

Added on Jun 12 2019

#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee

6 comments

1,418 views

2 mentions