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
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.