OBIEE11g Controlling Table, Pivot and Charts behaviour

In 11g it is still controlled by the instanceconfig.xml. You can edit the file and restart the system to see the effect.

Especially the MaxVisible.. parameters are of interest when you seem to “miss” data on the screen on large reports.

Be aware these are system wide controls, so don’t change the DefaultRowsDisplayed just for one report!

<ServerInstance>
  <Views>
      <Table>
        <MaxVisiblePages>1000</MaxVisiblePages>
        <MaxVisibleRows>500</MaxVisibleRows>
        <MaxVisibleSections>25</MaxVisibleSections>
        <DefaultRowsDisplayed>30</DefaultRowsDisplayed>
      </Table>
      <Pivot>
        <MaxVisibleColumns>300</MaxVisibleColumns>
        <MaxVisiblePages>1000</MaxVisiblePages>
        <MaxVisibleRows>500</MaxVisibleRows>
        <MaxVisibleSections>25</MaxVisibleSections>
        <DefaultRowsDisplayed>30</DefaultRowsDisplayed>
      </Pivot>
      <Charts>
        <MaxVisibleColumns>2000</MaxVisibleColumns>
        <MaxVisiblePages>1000</MaxVisiblePages>
        <MaxVisibleRows>2000</MaxVisibleRows>
        <MaxVisibleSections>25</MaxVisibleSections>
        <JavaHostReadLimitInKB>4096</JavaHostReadLimitInKB>
      </Charts>
  </Views>
</ServerInstance>

Till Next Time