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