OBIEE Server Configuration for Upgrade

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/fmwconfig/biconfig/OBIPS directory.
   2. Edit the file instanceconfig.xml.
   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.
2. Perform the following RPD changes, to set the Early Warning Indicators 1 and 2:
   1. Open the Repository in Online or Offline mode.
   2. Select Manage and then select Variables.
   3. Navigate to hierarchy Repository, select Variables, and then select Static.
   4. Modify EARLYWARNIND1 and EARLYWARNIND2 variable values as required.
   5. Save and commit the changes to RPD.

      Note:

      You must redeploy the RPD on the BI server if you have made changes in the offline mode.
3. For OBIEE reporting, configure the following:
   1. Navigate to the <<obiee <<Oracle BI Instance Home>/config/fmwconfig/biconfig/OBIJH directory.
   2. Modify the config.xml file.
   3. Increase the parameter value for the following tag:

      <XMLP>

      <InputStreamLimitInKB>40000</InputStreamLimitInKB>

      <ReadRequestBeforeProcessing>true</ReadRequestBeforeProcessing>

      </XMLP>

      <DVT>

      <InputStreamLimitInKB>40000</InputStreamLimitInKB>

      </DVT>

   4. Save the config.xml file.
   5. Navigate to the <<obiee <<Oracle BI Instance Home>/config/fmwconfig/biconfig/OBIPS directory.
   6. Modify the instanceconfig.xml file.
   7. Increase the parameter value for tag if already exists or add the following code:

      <Charts>

      <MaxVisibleColumns>50000</MaxVisibleColumns>

      <MaxVisiblePages>25000</MaxVisiblePages>

      <MaxVisibleRows>100000</MaxVisibleRows>

      <MaxVisibleSections>50000</MaxVisibleSections>

      <JavaHostReadLimitInKB>10240</JavaHostReadLimitInKB>

      </Charts>

      and

      <Pivot>

      <MaxCells>1920000</MaxCells>

      <MaxPagesToRollOutInDelivery>10000</MaxPagesToRollOutInDelivery>

      <MaxVisibleColumns>50000</MaxVisibleColumns>

      <MaxVisiblePages>100000</MaxVisiblePages>

      <MaxVisibleRows>10000000</MaxVisibleRows>

      <MaxVisibleSections>50000</MaxVisibleSections>

      <DefaultRowsDisplayed>100000</DefaultRowsDisplayed>

      </Pivot>

      under <Views> tag

   8. Save the instanceconfig.xml file.
   9. Restart the BI Services.