SAP Knowledge Base Article - Preview

2014786 - Data missing when exporting webi report to excel from BI 4.1 SP3

Symptom

Difference in behavior between BI 4.0 SP6 and BI 4.1 SP3 when exporting the webi reports to Excel format.
Some hard-coded cells are missing in Excel in BI 4.1 SP3.

1) When the report output is exported in Excel/Excel 2007 format or scheduled in these formats with Webi preference set as Prioritize easy
    data processing in Excel (default option), the excel output doesn't show values

2) When the report output is exported in Excel/Excel 2007 format or scheduled in these formats with Webi preference set as
    Prioritize the formatting of the documents, the excel output shows values of these cells in all tabs but the column order is changed as compared to BI 4.0.   

    Also, BI 4.0 shows proper values with Webi preference set as Prioritize easy data processing in Excel (default option).


Read more...

Environment

  • SAP BusinessObjects BI Platform 4.1 SP02
  • Web Intelligence (webi)

Product

SAP BusinessObjects Business Intelligence platform 4.1

Keywords

Webi export to Excel BI 4.1 SP3, Missing Values in Excel, Scheduling, Schedule, data, empty fields  , KBA , schedule to excel , BI-RA-WBI , Web Intelligence , Bug Filed

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.