Export to excel in 4.1
We have Webi document which always pull 200000+ records, When we trying to export the reports as Excel or PDF Its taking long (more that 20 mins to export). Is there anyway to increase the performence?
1)There is one work around that you can schedule the report to excel.
2)Also check the below property of web intelligence server.
- Login to Central Management Console (CMC) using BusinessObjects Enterprise "Administrator".
- Navigate to "Home >> Servers".
- Click on "Web Intelligence Report Server" to open its properties.
- Increase the "Maximum Binary File Size"(Default value=50 MBytes; Maximum value = 65535 MBytes).
- Click on "Apply" and then on "Update".
- Allow the Web Intelligence server to restart.
You can increase the size upto 200MB.