Tuesday, July 12, 2011

Exporting Financial Reporting (FR) 11.1.2.1 Reports to Excel Does Not Open in Excel, but in an Internet Explorer Tab or Page

Exporting Financial Reporting (FR) 11.1.2.1 Reports to Excel Does Not Open in Excel, but in an Internet Explorer Tab or Page [ID 1333633.1]
Modified 29-JUN-2011 Type PROBLEM Status PUBLISHED
In this Document
Symptoms
Cause
Solution
References

Applies to:

Hyperion BI+ - Version: 11.1.2.1.000 and later [Release: 11.1 and later ]
Information in this document applies to any platform.
Symptoms

When users in Workspace 11.1.2.1, export a Financial Reporting report in "Query Ready mode" or "Fully Formatted", the export process opens in an Internet Explorer tab or in a new Internet Explorer page and not in Excel Workbook.
Cause

This is an expected behavior under 11.1.2.1. The report opens correctly in Internet Explorer instead of Excel as there have been code changes in this area between system 9.3.1 and 11.1.2.1
Solution

To have the export open in Excel directly :

- Go to My Computer > Tools > Folder Option > File Types > Select XLS and click on advanced button. Un-check "Browse in Same window".

- Export a Financial Reporting report, it will be exported in Excel.

No comments:

Post a Comment