When Exporting to Excel, number of rows gets reduced with an "X" logo (OBIEE 11.1.1.7.140715)

Question

Hi guys,

When I am doing exporting of data after having operated a query, I noticed a few errors.

The data comes out messed up like this; in OBIEE, I get 6,000 or so entries, but here, I only get 3,865, with a noticeable 'X' here. Can anyone advise on what has happened and how I can mitigate this?

Thanks!

cesar.advincula.o · Answer

Yes,when your export data it depends on two variables:

- The setting of  InputStreamLimitInKB

- The rows number which are download in Oracle Enterprise Manager.

Setting it for your requirment.

Kind Regards,

3156138 · Answer

Hi Cesar,

Many thanks for the thorough explanation. Would I be right to say that this error is caused by too little heap size to export to Excel?

cesar.advincula.o · Answer

Please, remember Oracle BI is a web analytics system, if you want to show from bi analytics these 10 millions rows, you first could have a real good storage in your server and your client. In my experience, to show that huge amount of data it's no practical for to end users. However, Oracle as a BI Enterprise Platform, has two ways for your requirement: 1. If you want to show by default, you have to set up your instanceconfig.xm, check this links (Configuring and Managing Analyses and Dashboards - 11g Release 1 (11.1.1)), which is in /instance/config/OracleBIPresentantionServiceComponent/coreapplication_obips1\instanceconfig.xml 2. Or you could set up, in Oracle BI Presentation, Pivot Table 3, Table: Kind Regards,