Financial Reporting (FR) Report Export To Excel Results In Blanks Rows Between The Data Rows
Last updated on NOVEMBER 03, 2015
Applies to:Hyperion BI+ - Version 220.127.116.11.000 and later
Information in this document applies to any platform.
FR reports exported to Excel can't be used to do Excel calculations as there are blank rows between the value rows.
FR report is exported from Workspace as File--->Export
Once the report is in Excel, the following option is selected to present the dimension names in a single line: "merge and wrap text option" is removed. After this, the Excel sheet will have many empty rows which will prevent users form doing Excel calculations until all the empty rows are deleted.
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