SAP Knowledge Base Article - Preview

2114943 - BI 4.x - Time fields display as hashes when exporting a Web Intelligence document to Excel format


  • When saving a Web Intelligence report as Excel, columns with a time format are showing as negative numbers in Excel and therefore displaying as hashes.
  • This is happening with data from a new universe in 4.x.
  • The dimension is set as a datetime type.



  • SAP BusinessObjects Business Intelligence Platform 4.x
  • MS Excel 2010


SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1


bi businessobjects hash excel 2010 webi bilaunchpad timefields date exporttoexcel webi4.0 webi4.1 web intelligence negative numbers , KBA , BI-RA-WBI , Web Intelligence , Problem

About this page

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

Search for additional results

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