SAP Knowledge Base Article - Preview

1196247 - Desktop Intelligence mishandles format of columns retrieved from a Personal Data Connection with MS Excel file


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.



SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI


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.