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:
(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:
(click to enlarge)
The Data Query Optimization Settings window will pop up. Uncheck the box for Essbase Queries Use MDX, and click OK:
(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:
- Contact us using the form here, or call us at 952.947.9300.
- Drowning in data but parched for predictive insights? Arrange a free half-day analytics health check.
- Talk to our experts face to face at one of our upcoming industry events.
