Exceeded configured maximum number of allowed output records

Some time while running the report you will get error “Exceeded configured maximum number of allowed output ROW” In OBIEE Default result row limit is 65,000. If you are pulling more record then you have to increase the MaxVisibleRows.

Solution: Increase row size in Instanceconfigu.Xml

File Path:

C:\OBIEE11g\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\instanceconfig.xml R

<Views>

<Pivot>
<MaxCells>6500000</MaxCells>
<MaxVisibleColumns>100</MaxVisibleColumns>
<MaxVisiblePages>100</MaxVisiblePages>
<MaxVisibleRows>65000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<DefaultRowsDisplayed>500</DefaultRowsDisplayed>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager--><DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager--><DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager--><DisableAutoPreview>false</DisableAutoPreview>
</Pivot>
<Table>
<MaxCells>6500000</MaxCells>
<MaxVisiblePages>100</MaxVisiblePages>
<MaxVisibleRows>100000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<DefaultRowsDisplayed>500</DefaultRowsDisplayed>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager--><DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager--><DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload>
</Table>
</View>


Thank you,

Keep visiting for new posts.:)

Exceeded configured maximum number of allowed input records

Some time while running the report you will get error “Exceeded configured maximum number of allowed output ROW” In OBIEE Default result row limit is 65,000. If you are pulling more record then you have to increase the MaxVisibleRows.

Solution: Increase row size in Instanceconfigu.Xml

File Path:

C:\OBIEE11g\instances\instance1\config\OracleBIPresentationServicesComponent\coreapplication_obips1\instanceconfig.xml R

<Views>

<Pivot>
<MaxCells>6500000</MaxCells>
<MaxVisibleColumns>100</MaxVisibleColumns>
<MaxVisiblePages>100</MaxVisiblePages>
<MaxVisibleRows>65000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<DefaultRowsDisplayed>500</DefaultRowsDisplayed>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager--><DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager--><DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager--><DisableAutoPreview>false</DisableAutoPreview>
</Pivot>
<Table>
<MaxCells>6500000</MaxCells>
<MaxVisiblePages>100</MaxVisiblePages>
<MaxVisibleRows>100000</MaxVisibleRows>
<MaxVisibleSections>25</MaxVisibleSections>
<DefaultRowsDisplayed>500</DefaultRowsDisplayed>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager--><DefaultRowsDisplayedInDelivery>75</DefaultRowsDisplayedInDelivery>
<!--This Configuration setting is managed by Oracle Business Intelligence Enterprise Manager--><DefaultRowsDisplayedInDownload>65000</DefaultRowsDisplayedInDownload>
</Table>
</View>


Thank you,

Keep visiting for new posts.:)

OBI Report Navigation Using Action Links

                  Following are the steps to create report navigation using action links:

1.       Create master report as shown bellow

 

2.       Create detailed report as shown bellow

3.       Apply filters as shown in master and detailed report.

4.       To create action link

1.       Go to column properties, in interaction tab.

2.       Add new action link, select option navigate to BI content

3.       Browse and select detailed report.

4.       Click OK.

5.       Action Link added.

5.       Put master report on dashboard.

6.       In this report you will see the drill down option.

7.       Click on the detail to navigate to detailed report

8.       Hence implemented the report navigation using action links.

OBI Report Navigation Using Action Links

                  Following are the steps to create report navigation using action links:

1.       Create master report as shown bellow

 

2.       Create detailed report as shown bellow

3.       Apply filters as shown in master and detailed report.

4.       To create action link

1.       Go to column properties, in interaction tab.

2.       Add new action link, select option navigate to BI content

3.       Browse and select detailed report.

4.       Click OK.

5.       Action Link added.

5.       Put master report on dashboard.

6.       In this report you will see the drill down option.

7.       Click on the detail to navigate to detailed report

8.       Hence implemented the report navigation using action links.