I was working over my tables and observing the records. Suddenly the pivot table prompted an error message that says error code ekmt3fk5 oi2dl65p. How can I fix it?
Stop your OBIEE services and then go to the path D: \ << Middleware folder >> \ Instances \ Instance1 \ Config \ OracleBIPresentationServicesComponent \ Coreapplication_obips1
Then Save your instanceconfig.xml file and open the instanceconfig.xml file. Make sure you have the Cubes section with the following value
<Cube>
<CubeMaxRecords> 100000000 </ CubeMaxRecords>
<CubeMaxPopulatedCells> 100000000 </ CubeMaxPopulatedCells>
</ Cube>
Make sure the following settings are present in the Pivot section.
<DefaultRowsDisplayed> 1000 </ DefaultRowsDisplayed>
Make sure the section of the table contains the following parameters
<DefaultRowsDisplayed> 1000 </ DefaultRowsDisplayed>
Re-start OBIEE services
