Sometimes, Hyperion Financial Reporting studio can run into an error upon the launch of a report. This can be frustrating when hours have been put in to build a dynamic, nice looking report, only to receive the below message when it is run:

Hyperion Financial Reporting Internal Essbase JAPI error

(click to enlarge)

This is something that has come up a couple of times recently, and so sharing the fix seemed appropriate. What is happening here is that Financial Reporting is trying to generate an MDX query to run against the cube to generate the data set, but is running into an issue with the query that is being generated.

Luckily, the fix is quick and easy. We can tell Financial Reporting to use the Grid API (similar to an Excel retrieve) rather than MDX to get the data.  To do this, we navigate to Task→Data Query Optimization Settings:

Hyperion Financial Reporting - Data Query Optimization Settings

(click to enlarge)

The Data Query Optimization Settings window will pop up. Uncheck the box for Essbase Queries Use MDX, and click OK:

Hyperion Financial Reporting - Uncheck the box for Essbase Queries Use MDX,

(click to enlarge)

Save the report, and run it. An error should no longer be generated, and the report should successfully run.

Have more questions? We can help:


Jon Harvey

Jon has been a part of the Oracle team at eCapital Advisors since 2009 and is passionate about educating and teaching clients and team members how to apply the technology to drive business value within organizations. An Oracle Certified Expert in both Hyperion Planning and Essbase, Jon oversees the technical aspects of EPM project delivery and managed services. In addition, he’s responsible for ensuring the continued growth of the practice’s technical capabilities and serves as the primary interface between eCapital and the Oracle user community.

Comments are closed.