Oracle Analytics and AI

User128178 - Oracle

Customer is trying to dowlanload reports using IQY from answers advanced tab using Excel.

For large number of records EXcel is not opening and throwing an error message

After giving our username and password, the Microsoft Excel starts fetching data but eventually fails giving below error.

Error: Unable to open <Delta url>. Cannot download the information you requested.

We have increased the row limit in instanceconig.xml file

Using OBIEE 11.1.1.7 and excel 2013

[Deleted User]

User128178 - Oracle wrote:
We have increased the row limit in instanceconig.xml file

You have increased what to what setting? There are about 20 parameter in the instanceconfig which have to do with "rows". And many more which have an impact on the amount of columns, data etc.

Plus you also need to increase the JavaHost limits.

Please be precise on WHAT you're doing, WHAT you've done exactly etc.