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:

Symptoms

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.
https://docs.oracle.com/en/database/other-databases/essbase/21/essoa/expand-limit-sql-clauses-drill-reports.html#GUID-240C70E7-8336-4520-B6D1-8E9A24C301D7

Changes

Cause

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