9.3.6.1 OBIEE Server Configuration Steps

Perform the following OBIEE Server Configuration Steps. You can ignore the steps if OBIEE is already configured in your setup.

  1. Perform the following OBIEE presentation Server Configuration Steps
    1. Navigate to the <Oracle BI Instance Home>/config/OracleBIPresentationServicesComponent/coreapplication_o bips1> directory.
    2. Edit the instanceconfig.xml file.
    3. Insert the following code within the XML tag
      <Views> </Views>.
      <Charts>
      <MaxVisibleColumns>50000</MaxVisibleColumns>
      <MaxVisiblePages>25000</MaxVisiblePages>
      <MaxVisibleRows>10000000</MaxVisibleRows>
      <MaxVisibleSections>50000</MaxVisibleSections>
      <JavaHostReadLimitInKB>10240</JavaHostReadLimitInKB>
      </Charts>
    4. Insert the following code within the XML tag
      <Views> </Views>. 
      <Table>
      <DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
      <DefaultRowsDisplayedInDownload>6500</DefaultRowsDisplayedInDownload>
      <MaxCells>4000000</MaxCells>
      <MaxVisibleRows>140000</MaxVisibleRows>
      </Table>
      <Narrative>
      <MaxRecords>500000</MaxRecords>
      <DefaultRowsDisplayed>25</DefaultRowsDisplayed>
      </Narrative>
      
    5. Save the file and restart the BI services.

      Note:

      Take a backup of the instanceconfig.xml file before making any changes.