Configuring Views OBIEE 11g

In OBIEE 11g we need to configre the Views to manually increase the limit of records/rows it can be displayed in a pivot/table/cube. You have to make these changes in instanceconfig.xml and restart the presentation server.


<ServerInstance>
  <Views>
    <Cube>
      <CubeMaxRecords>60000</CubeMaxRecords>
      <CubeMaxPopulatedCells>240000</CubeMaxPopulatedCells>
    </Cube>
   <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>