"Get more rows" message in OBIEE pivot table

Johan (South Africa)

Hi everyone

I get a "Get more rows" message at the bottom of a OBIEE 12c pivot table. 1000 Rows are displayed by default and I have to click on this message in order to display more rows.

How do I disable this message or increase the number of records to be displayed before it appears?

This is the contents of the instanceconfig.xml file at the moment:

<Views>

<Pivot>

<MaxPagesToRollOutInDelivery>10000</MaxPagesToRollOutInDelivery>

<MaxVisibleColumns>100</MaxVisibleColumns>

<MaxVisiblePages>1048400</MaxVisiblePages>

<MaxVisibleRows>10000000</MaxVisibleRows>

<MaxVisibleSections>5000</MaxVisibleSections>

<DefaultRowsDisplayedInDelivery>9999999</DefaultRowsDisplayedInDelivery>

<DefaultRowsDisplayedInDownload>9999999</DefaultRowsDisplayedInDownload>

<DisableAutoPreview>false</DisableAutoPreview>

<MaxCells>104857600</MaxCells>

<DefaultRowsDisplayed>1000000</DefaultRowsDisplayed>

</Pivot>

Thanks

Johan

[Deleted User]

There's more than just that snippet of the instanceconfig. Check the documentation:

https://docs.oracle.com/middleware/bi12214/biee/BIESG/GUID-FF6954BA-2DE0-4422-BA58-05F32936F4FF.htm#BIESG1719