My Oracle Support Banner

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 AUGUST 11, 2021

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.


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

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