We have problem to export WebI report to Excel 2007.
Error message :
Steps to Reproduce:
A big report returning 100000 rows
schedule the report, choose destination to excel 2007
- windows 2008r2 and windows 2012
- boxi 3.1 SP7
The default config of WebIntelligenceProcessingServer is not adapted to big report
A temporary file (*.xml) is generated in the following directory when viewing the document. The error occurs if the temporary file size is bigger than Maximum Character Stream Size (BO XI R2: Maximum Character File Size) of Web Intelligence Processing Server (BO XI R2: Web Intelligence Report Server).
The Web Intelligence Processing Server (BO XI R2: Web Intelligence Report Server) configuration parameter
Maximum Character Stream Size (MB) (BO XI R2: Maximum Character File Size) is too small for the output.
Increase this value in the Central Management Console (CMC).