SAP Knowledge Base Article - Preview

2182319 - Incorrect SUM aggregation values when exporting BO XI 3.1 Web Intelligence reports to Excel 2007 (.xlsx) format

Symptom

  • When exporting a Web Intelligence report to Excel 2007 (.xlsx) format, the result of the SUM function is incorrect in the Excel document.
  • In the Excel 2007(.xlsx) generated spreadsheet a single cell can be found in two merged rows (32-33).
    (The reason is described in KBA 1230109.)
  • When exporting to .xls format, the value is correct.

symp.png

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."


Read more...

Environment

  • SAP BusinessObjects Enterprise XI 3.1 SP7 FP7.2
  • Web Intelligence
  • Microsoft Office

Product

SAP BusinessObjects Enterprise XI 3.1

Keywords

webi, web intelligence, incorrect SUM, .xlsx, .xls, excel output, extra rows, additional cells, alignment, relative position, width , KBA , BI-RA-WBI-FE , Front End/Client , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.