Web Analysis Html Export To Excel Fails For Report Attached To Sql Server Data Source ( relational reports) (Doc ID 1382083.1)

Last updated on AUGUST 08, 2016

Applies to:

Hyperion BI+ - Version 9.3.3.0.00 to 11.1.1.4.104 [Release 9.3 to 11.1]
Information in this document applies to any platform.

Symptoms

 

 


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.”

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