My Oracle Support Banner

Essbase 21c On Premise: Drill-through Not Working At Higher Levels In Hierarchy When Running Against Oracle Database (Doc ID 2975324.1)

Last updated on SEPTEMBER 26, 2023

Applies to:

Hyperion Essbase - Version and later
Information in this document applies to any platform.


When attempting to run a drill-through report from Smart View on upper level cells, it fails. When running drill-through on level 0 cells, it works fine.

The drill-through report is running against an Oracle database.

Following error is displayed:
Failed to execute the Drill-Through request. Refer the Provided Service logs to more details

It was already attempted to use the following solution from the documentation:

Resolve a drill through reports error by increasing the SQL IN clause limit beyond the default of 1000 members.




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.