Pivot Tables & CUBE Limits

Cube Limit for Pivot Table can be increased following steps:

1. Stop the services: IIS Service admin, Oracle BI Server, Oracle Presentation Server, Oracle BI Scheduler, Oracle BI Java Host.

2. Check the syntax in the Instanceconfig.xml, it should be:

<PivotView>
<MaxCells> 4000000 </MaxCells>
<MaxVisibleColumns> 5000 </MaxVisibleColumns>
<MaxVisiblePages> 2500 </MaxVisiblePages>
<MaxVisibleRows> 75000 </MaxVisibleRows>
<MaxVisibleSections> 3000 </MaxVisibleSections>
<ResultRowLimit>20000</ResultRowLimit>
</PivotView>
<CubeMaxRecords> 1000000 </CubeMaxRecords>
<CubeMaxPopulatedCells> 1000000 </CubeMaxPopulatedCells>

Restart the Services, if still not works try step 3.

3. Creating the registry variables:
a) Start > Run > regedit
b) Go to HKEY_LOCAL_MACHINE > ORACLE >Business Intelligence
c) Create 2 new string values : CubeMaxRecords with value 150000 and other CubeMaxPopulatedCells with value 160000.
d) Similarly create the same 2 string parameters at the location : HKEY_LOCAL_MACHINE > Siebel Systems, Inc. > Siebel Analytics > Web > 7.7
(If the location mentioned above is not present create it)

4. Start the services.


Cheers ;)