Monday, January 7, 2013

Exceeded configured maximum number of allowed output prompts in OBIEE 11g


Error : Exceeded configured maximum number of allowed output prompts, sections, rows in OBIEE 11g.

When we are drilling from main report to detail report we are getting an error like Exceeded configured maximum number of allowed output prompts, sections, rows this is because of huge data in the report.
So in order to resolve this issue we need to add the below mentioned  tags in instanceconfig.xml file which is located under
\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1
The tags which needs to be added are