/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
Desktop Intelligence mishandles the data type when a Microsoft Excel Spreadsheet which contains columns of mixed data type is used on a Personal Data Connection.
For example, if you have an Excel file in which there is a column containing text, number and date values, the text fields will be replaced by zeroes, dates will be replaced by a number and the number will remain a number.
This behaviour happens regardless of the format settings within Excel and also when any or all of the cells are formatted as Text.
Read more...
Product
SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI
Keywords
deski, excel, import, personal data connection, mixed value , 2030134 , KBA , BI-RA-DKI , Obsolete - Desktop 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.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)