The most common things we hear from client when we deliver a report is how can i download it as a Excel or PDF. It's an easy answer for any one to tell just export it.
Now lets see how to change the no of rows that are allowed in download. Generally the allowed limit is 2500 rows. This is a system administrator job and any one with Administrator role can do this.
Now lets see how to change the no of rows that are allowed in download. Generally the allowed limit is 2500 rows. This is a system administrator job and any one with Administrator role can do this.
- Login to Enterprise Manager
- Navigate to Business Intelligence - Coreapplication - Capacity Management - Performance
- Now to change the default values click on Lock and Edit Configuration
- Change the "No Of Rows" under "Maximum Number of Rows to Download"
- Once you are done with changes click on "Activate Changes"
- To get the changes effective Restart All the BI services.
We can also change the no of rows displayed, Session expire minutes, Global Cache ,Cache Management etc .. in the same way as above.
this works only for Export-Data as CSV Format. Still in excel we are getting less number of rows only
ReplyDeleteThis does not work. It shows an error when trying to download report in PDF or Excel.
ReplyDelete