Financial Reporting (FR) Report With Function Bottom Of Hierarchy Returns Error 'Error Executing Query: Error: Internal Essbase JAPI Error: [Cannot Execute Report. Essbase Error(1013033):ReportWriter Exit Abnormally]'
(Doc ID 2876354.1)
Last updated on JUNE 16, 2022
Applies to:Hyperion BI+ - Version 184.108.40.206.000 to 220.127.116.11.000 [Release 11.2]
Information in this document applies to any platform.
Essbase Aggregate Storage Option (ASO) application
When attempting to run an FR report which contains an advance member selection function of "Bottom of hierarchy <member_name>" in a column, the following error occurs.
Error executing query: Error: Internal Essbase JAPI
error: [Cannot execute report. Essbase Error(1013033):
ReportWriter exit abnormally]
From FR Web Studio's Task->Data Query Optimization Settings, the following changes had no effect in correcting the error.
- Change default "Database Connection Server" to "Report Server" option.
- Change default Essbase Queries use MDX "Combine queries using WITH MEMBER" to "Use separate queries" option.
- Uncheck the box for "Essbase Queries use MDX" option.
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