If we exceeds maximum number of records in Pivot table,it will shows Governor limit exceeded error in Pivot view.
If we want some other data other than Governor limit error,then follow the below steps:
1.Navigate to C:\OBIEE_HOME\web\msgdb\l_en\messages\cubemessages.
2.Open cubemessages xml file and search for kmsgCubeGovernorExceeded”.
3.Customize the message within the <TEXT> tag i.e No.of records have exceeded ,Kindly apply some more filters.
4.Restart the services.
5.XML file customizes the error text with our required text.
