1 Reply Latest reply on May 15, 2019 2:08 PM by Christian Berg

    "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