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. 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.