This content has been marked as final. Show 4 replies
The issue is the number of cells in your result in more than the specified limit in instanceconfig.xml.
You can increase the limit in instanceconfig.xml.
increase the value in <MaxCells>1920000</MaxCells> tag.
Follow the blog below.
Hi,1 person found this helpful
Configure Max Cell value properly which should be multiple of MaxVisibleColumns and MaxVisibleRows
Refer : http://deliverbi.blogspot.in/2011/12/obiee-11g-row-settings-table-and-pivot.html
So I need to multiply the MaxVisibleColumns and MaxVisibleRows? Since I dont include the MaxVisibleColumns in the file. So it is required to put this as well in the file? or just making the Max Cell value paroperty bigger will do??
Just make Max Cells equal to multiple of Rows and Columns, no need to include.