Hi All,
One of my reports contains Pivot table. This report is constrained on weeks. When I select a wider range of weeks, it returns the following error.
"Governor Limit exceeded in cube generation & the maximum data records exceeded. "
I reset the following entries in the instanceconfig.xml file as follows.
<PivotView>
<MaxCells>600000</MaxCells>
<CubeMaxRecords>600000</CubeMaxRecords>
<CubeMaxPopulatedCells>600000</CubeMaxPopulatedCells>
</PivotView>
I restarted all the services but still I am getting
"Governor Limit exceeded in cube generation & the maximum data records exceeded. "
I even executed sql on the database and could figure out this error happens only when the result of sql returns 40,560 rows i.e more than 40,000, but it works fine for result set of 39,450 rows.
Is there any limitation on number of rows processed by a pivot table?
If there is I believe it can be reset by using <CubeMaxRecords>600000</CubeMaxRecords> entry in instanceconfig.xml file. In this case which is set well above 40,000 i.e 600,000.
Any clarification and suggestions would be highly appreciated.
Regards,
Aniket