OBIEE instanceconfig.xml

Some of the settings in your instanceconfig.xml file are maintained and set through the enterprise manager - usually available on http://localhost:7001/em.

I have found that sometimes (actually make that usually) the analysts want to consume and display more data than the default settings allow. But be aware that there is always a trade off, if you increase numbers somewhere, there is a knock on somewhere else, maybe a slower response as more rows are analysed by default. There are other side effects on the performance side, but none that need worry us here.

configuration changes in the instanceconfig.xml file

<Views>

<Pivot>

<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>

<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

<DefaultRowsDisplayedInDownload>250000</DefaultRowsDisplayedInDownload>

<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

<DisableAutoPreview>false</DisableAutoPreview>

</Pivot>

<Table>

<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>

<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->

<DefaultRowsDisplayedInDownload>250000</DefaultRowsDisplayedInDownload>

</Table>

<Charts>

<EnableWaterfall>true</EnableWaterfall>

</Charts>

</Views>

Change the instanceconfig.xml file in <biee11g_install>\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1 as following

Look for the Views section and edit until the section looks something like:

<Views>
<Pivot>
<MaxCells>1920000</MaxCells>
<MaxVisibleColumns>30</MaxVisibleColumns>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>64000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<DefaultRowsDisplayed>64000</DefaultRowsDisplayed>
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>64000</DefaultRowsDisplayedInDownload>
<DisableAutoPreview>false</DisableAutoPreview>

</Pivot>
<Table>
<MaxCells>1920000</MaxCells>
<MaxVisiblePages>1000</MaxVisiblePages>
<MaxVisibleRows>64000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<DefaultRowsDisplayed>64000</DefaultRowsDisplayed>
<DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<DefaultRowsDisplayedInDownload>64000</DefaultRowsDisplayedInDownload></Table>
</Views>


Now Restart Presentation Server from EM, then run your request, do excel export to verify.

Remember, OBIEE is not a data extraction tool, and should not be configured to allow very large data extacts. This has some fairly significant performance implications.