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
1 person found this helpful
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,