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
Last updated on APRIL 02, 2018
Applies to:Hyperion BI+ - Version 22.214.171.124.000 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