Web Analysis Html Export To Excel Fails For Report Attached To Sql Server Data Source ( relational reports)
Last updated on AUGUST 08, 2016
Applies to:Hyperion BI+ - Version 184.108.40.206.00 to 220.127.116.11.104 [Release 9.3 to 11.1]
Information in this document applies to any platform.
Cannot get the “Export to Excel” for SQL data sources. It works fine when Essbase is the data source. The following three scenarios fail when exporting to Excel from HTML Web Analysis
1. Selecting “Export to Excel” from left window pane fails.
2. Selecting “File => Export => Excel => Query-Ready Grid and Text or Fully formatted Grid and Text” also fails.
3. Right clicking on grid and selecting “Export to Microsoft Excel” also fails, but does open Excel with the following Excel error message: “This Web query returned no data. To modify the query, click the name of the external data range in the name box on the formula bar, and then click Edit Query on the External Data toolbar.”
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