Monday, December 1, 2014

FETCH FIRST 65001 ROWS ONLY OBIEE 11g

By default OBIEE Analysis returns 65000 records for a report, it can be updated as per your business requirement. Here is the steps to be followed

1. Log into Enterprise Manager (EM)
2. Click on "Business Intelligence"
3. Click on "coreapplication" ->   "Capacity Management" Tab -> "Performance" tab
4. Modify the value "Maximum Number of Rows Processed when Rendering a Table View"
    Lock and edit configuration
    Enter Value as per requirement.
5. Restart Presentation services.

1 comment: