OBIEE11g: Changing the Configuration Limits of Different Views(Table,Pivot Table,Trellis,Charts etc) in INSTANCECONFIG.XML file of OBIEE11g

Scenario:

The number of records that should be shown in the Views(Table,Pivot Table,Trellis,Charts etc) will be configured in the INSTANCECONFIG.XML file. There are some default settings which is applied to the Views, You can change those default settings if you want to increase/decrease the limits by editing or adding few tags in INSTANCECONFIG.XML file. For example the default number of records displayed in any of the views would be 65,000 if the reports is getting more than the default limit then you get an error message saying that max number of cube records are exceeded. In this kind of situations we can fix this issue by changing the default configurations.

<ODBC>
<!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
<ResultRowLimit>700000</ResultRowLimit>
</ODBC>

NOTE: 
1) You should take a back up of Instanceconfig.xml file before editing.
2) These tags should be added in between <ServerInstance> </ServerInstance> only
3) Few of the tags will be present in the instanceconfig.xml file by default in that case we dont need to add them again just go and change the number in between the tags as per requirement. If you dont find the tag related to a specific view then you can add it as shown below.

 To manually edit the settings:

1. Open the instanceconfig.xml file for editing (
   ORACLE_INSTANCE\config\OracleBIPresentationServicesComponent\coreapplication_obipsn
   For example:
   \instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1)
   
   
2. Locate the Cube section, in which you must add the following elements: If you dont find the cube section then add it.
   
   • CubeMaxRecords — Specifies the maximum number of records that are returned by an analysis for the view to process. This roughly governs the maximum number of cells that can be populated in a view; unpopulated cells in a sparse view do not count. The default is 40000.
     
   • CubeMaxPopulatedCells — Specifies the maximum number of cells in a view that can be populated with data from the Oracle BI Server. The default is 120000.
     
3. Include the elements and their ancestor elements as appropriate, as shown in the following example:
   

    <ServerInstance>

   <ODBC>
   <!--This Configuration setting is managed by Oracle Enterprise Manager Fusion Middleware Control-->
   <ResultRowLimit>700000</ResultRowLimit>
   </ODBC> 

     <Views>
       <Cube>
         <CubeMaxRecords>40000</CubeMaxRecords>
         <CubeMaxPopulatedCells>120000</CubeMaxPopulatedCells>
       </Cube>
         <Table>
           <MaxCells>10000</MaxCells>
           <MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>
           <MaxVisiblePages>1000</MaxVisiblePages>
           <MaxVisibleRows>500</MaxVisibleRows>
           <MaxVisibleSections>25</MaxVisibleSections>
           <DefaultRowsDisplayed>30</DefaultRowsDisplayed>
           <DefaultRowsDisplayedInDelivery>250</DefaultRowsDisplayedInDelivery>
           <DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload>
         </Table>
         <Pivot>
           <MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>
           <MaxVisibleColumns>300</MaxVisibleColumns>
           <MaxVisiblePages>1000</MaxVisiblePages>
           <MaxVisibleRows>500</MaxVisibleRows>
           <MaxVisibleSections>25</MaxVisibleSections>
           <DefaultRowsDisplayed>30</DefaultRowsDisplayed>
           <DefaultRowsDisplayedInDelivery>250</DefaultRowsDisplayedInDelivery>
           <DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload>
         </Pivot>
         <Trellis>
           <Simple>
               <MaxCells>1000</MaxCells>
               <MaxVisibleSections>10</MaxVisibleSections>
               <MaxVisiblePages>1000</MaxVisiblePages>
               <MaxVisibleRows>100</MaxVisibleRows>
               <MaxVisibleColumns>75</MaxVisibleColumns>
               <MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>
               <DefaultRowsDisplayed>10</DefaultRowsDisplayed>
               <DefaultRowsDisplayedInDelivery>100</DefaultRowsDisplayedInDelivery>
               <DefaultRowsDisplayedInDownload>6500</DefaultRowsDisplayedInDownload>
           </Simple>
           <Advanced>
               <MaxCells>5000</MaxCells>
               <MaxVisibleSections>50</MaxVisibleSections>
               <MaxVisiblePages>1000</MaxVisiblePages>
               <MaxVisibleRows>250</MaxVisibleRows>
               <MaxVisibleColumns>150</MaxVisibleColumns>
               <MaxPagesToRollOutInDelivery>1000</MaxPagesToRollOutInDelivery>
               <DefaultRowsDisplayed>25</DefaultRowsDisplayed>
               <DefaultRowsDisplayedInDelivery>250</DefaultRowsDisplayedInDelivery>
               <DefaultRowsDisplayedInDownload>10000</DefaultRowsDisplayedInDownload>
           </Advanced>
         </Trellis>
         <Charts>
           <MaxVisibleColumns>2000</MaxVisibleColumns>
           <MaxVisiblePages>1000</MaxVisiblePages>
           <MaxVisibleRows>2000</MaxVisibleRows>
           <MaxVisibleSections>25</MaxVisibleSections> 
           <EmbedFonts>True</EmbedFonts>
           <SectionSliderDefault>150</SectionSliderDefault>
           <SectionSliderLimit>300</SectionSliderLimit>
           <JavaHostReadLimitInKB>4096</JavaHostReadLimitInKB>
         </Charts>
         <Narrative>
           <MaxRecords>40000</MaxRecords>
           <DefaultRowsDisplayed>30</DefaultRowsDisplayed>
         </Narrative>
         <Ticker>
           <MaxRecords>40000</MaxRecords>
         </Ticker>
     </Views>

    </ServerInstance>
   

4. Save your changes and close the file.
   
5. Restart Oracle Business Intelligence Services (OPMN Services).

Element	Description	Default Value	Applicable Views
DefaultRowsDisplayed	Specifies the default number of rows to display in views in analyses and dashboards. This number should not exceed the number that is specified for the MaxVisibleRows element.	25 (10 for Simple Trellis)	Narrative, Pivot Table, Table, Trellis
DefaultRowsDisplayedInDelivery	Specifies the default number of rows that can be included in the view when it is displayed on a dashboard.	100 for Simple Trellis; 250 for Advanced Trellis, Table, and Pivot Table	Pivot Table, Table, Trellis
DefaultRowsDisplayedInDownload	Specifies the default number of rows that can be included in the view when it is downloaded, such as to a PDF file.	65000 (6500 for Simple Trellis; 10000 for Advanced Trellis)	Pivot Table, Table, Trellis
MaxCells	Specifies the maximum number of cells to be displayed in a view. This number should not exceed the product of MaxVisibleColumns times MaxVisibleRows, which is what the system attempts to render.	50000 (1000 for Simple Trellis)	Pivot Table, Table, Trellis
MaxPagesToRollOutInDelivery	Specifies the maximum number of pages that can be included in the view when it is displayed on a dashboard.	1000	Pivot Table, Table, Trellis
MaxRecords	Specifies the maximum number of records that can be included in the view.	40000	Narrative, Ticker
MaxVisibleColumns	Specifies the maximum number of columns to be displayed in a view.	300 (75 or Simple Trellis; 150 for Advanced Trellis)	Graph, Pivot Table, Trellis
MaxVisibleRows	Specifies the maximum number of rows to be displayed in a view. The value of DefaultRowsDisplayed should not exceed this value. For tables and pivot tables, specifies the following: The number of rows that is displayed on the tooltip for the Display Maximum Rows per Page paging control button. The uppermost value to specify for the Maximum Number of Rows to Download and the Maximum Number of Rows Per Page to Include options in Fusion Middleware Control.	500 (100 or Simple Trellis; 250 for Advanced Trellis)	Graph, Pivot Table, Table, Trellis
MaxVisiblePages	Specifies the maximum number of view prompts (or pages in PDF) to be displayed in a view.	1000	Graph, Pivot Table, Table, Trellis
MaxVisibleSections	Specifies the maximum number of sections to be displayed in a view. This element does not apply when a slider is in place for a graph. The SectionSliderDefault and SectionSliderLimit elements apply to limit section values when a slider is in place.	25 (10 or Simple Trellis; 50 for Advanced Trellis)	Graph, Pivot Table, Table, Trellis
JavaHostReadLimitInKB	Specifies the maximum amount of data that is sent to the browser for a single graph.	4096	Graph