If you want to download, unlimited row.
Please,go to the follow path:
<Oracle BI Instance>/instance<N>/config/OracleBIJavaHostComponent/coreapplication_obijh1
Edit the "config.xml" file:
Go Oracle Enterprise Manager
Go to the
<Oracle BI Instance>/instance<N>/config/OracleBIPresentantionServiceComponent/coreapplication_obips1\instanceconfig.xml
If you want information in more detail please visit this web site https://docs.oracle.com/cd/E29542_01/bi.1111/e10541/answersconfigset.htm#BIESG1705
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 <Oracle BI Instance>/instance<N>/config/OracleBIPresentantionServiceComponent/coreapplication_obips1\instanceconfig.xml
2. Or you could set up, in Oracle BI Presentation,
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?
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.