Financial Reporting (FR) Report Export To Excel Results In Blanks Rows Between The Data Rows (Doc ID 1675181.1)

Last updated on NOVEMBER 03, 2015

Applies to:

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

Symptoms

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.

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