Financial Reporting (FR) Report Exported to Excel as Fully Formatted, the Grids and Text Replace Dash "-" with 0 (zero) in Excel Spreadsheet
Last updated on APRIL 30, 2018
Applies to:Hyperion BI+ - Version 22.214.171.124.501 and later
Information in this document applies to any platform.
You have a FR report in which a column and/or row has blank values, for example, "No Data".
In the report's Grid Properties box, "No Data" is replaced with a dash "-".
In Workspace, you perform HTML Preview on the report. Next, you click on the active link "Fully Formatted Grids and Texts". When the report is exported to Excel, the dash(-) symbol is replaced by "0" in the Excel spreadsheet.
You have already applied Patch 19570230 (Patch Set Update: 126.96.36.199.503 for Oracle Hyperion Reporting and Analysis Financial Reporting Release 188.8.131.52.500) or higher on Financial Reporting Web Application server.
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