Paper at Oracle Business Intelligence Conference

I have just presented a paper with my colleague at the recent OBIEE conference held at the London Bridge Hotel on Tuesday 8th November. Nerve racking as we only had a day's notice, but the presentation was well received.

We were demonstrating what we have achieved combining spatial data, namely a road network, with business data, the mechanisms behind the scene and some of the output we produce.

Drop me line if you want a copy of the presentation.

-- Update

Oracle have kindly put the presentation up and you can view it here.

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.