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 DECEMBER 13, 2016

Applies to:

Hyperion BI+ - Version 11.1.2.2.000 and later
Information in this document applies to any platform.
3/17/14

Symptoms

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.

Cause

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