Exporting a Financial Reporting (FR) Report from Workspace to Excel in Query-Ready Mode does not Produce a Query-Ready Spreadsheet When Using a Hyperion Financial Management (HFM) Datasource

(Doc ID 1497335.1)

Last updated on APRIL 02, 2018

Applies to:

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


Create a Financial Reporting (FR) report that uses Hyperion Financial Management (HFM) as a datasource.  Perform an HTML Preview on the report in Workspace and select "Export In Query-Ready Mode".  When the report renders in Excel, no datasource connection exists. 

In order to run queries against the rendered report, a manual connection to HFM must be established via the Smart View Panel.  This is not truly query-ready because a reset of POV dimensions is required.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms