Symptom
When exporting full-client reports to Excel from BusinessObjects full-client and BusinessObjects in 3-tier mode (ZABO), date fields are being converted to text. This causes the text versions of dates to sort alphabetically instead of chronologically. When Excel auto filters are set, setting a filter Not Equal To will not work, nor will setting a date Between ranges.
Read more...
Product
SAP BusinessObjects Business Intelligence platform 6.5 ; SAP BusinessObjects Business Intelligence platform 6.5.3
Keywords
Date,Import,Excel , 4469115 , KBA , BI-BIP , Business intelligence platform , Problem
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.
SAP Knowledge Base Article - Preview