Manually Configuring Settings for Data in Narrative Views

Hi,

Let say i have table with 1000 rows data, when i try to use narrative view in analysis got below error narrative view it's not how so "many rows data in narrative view and MaxRecords limit exceeded error".this is know issues only by changing/adding instanceconfig.xml --> narrative view content then you can able to resolve it.

1) take a backup of your instanceconfig.xml file

C:\Oracle\Middleware\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\instanceconfig.xml

2) Narrative view you need to add below elements are,

just include <Views> b/w </Views>

<Narrative>

<MaxRecords>40000</MaxRecords>

<DefaultRowsDisplayed>1000</DefaultRowsDisplayed>

</Narrative>

3)Save your changes and close the file.

4) Restart Oracle Business Intelligence "Bi_Presentation_Services"

For More : instanceconfig.xml (increasing no of columns/rows)

http://docs.oracle.com/cd/E23943_01/bi.1111/e10541/answersconfigset.htm#CIHHBHAI

(note: refer section, 18.3.1.2 Manually Configuring Settings for Data in Views)