Financial Reporting (FR) Report Exported to Excel as Fully Formatted, the Grids and Text Replace Dash "-" with 0 (zero) in Excel Spreadsheet
(Doc ID 2044964.1)
Last updated on SEPTEMBER 19, 2024
Applies to:
Hyperion BI+ - Version 11.1.2.3.501 and laterInformation in this document applies to any platform.
Symptoms
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.
Changes
You have already applied Patch 19570230 (Patch Set Update: 11.1.2.3.503 for Oracle Hyperion Reporting and Analysis Financial Reporting Release 11.1.2.3.500) or higher on Financial Reporting Web Application server.
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |