Symptom
When attempting to sort a Web Intelligence document on a particular column, special characters such as "-" or "." are not respected. For example, add the following into a database and then create a Web Intelligence report.
a-Austria
a-Austrailia
a-Austrailia
a-Belgium
a B-Argentina
a B-Brazil
a B-Egypt
a B-Argentina
a B-Brazil
a B-Egypt
When you sort this data in Web Intelligence it appears as:
a-Austria
a-Austrailia
a B-Argentina
a B-Brazil
a B-Egypt
a-Austrailia
a B-Argentina
a B-Brazil
a B-Egypt
a-Belgium
Read more...
Product
SAP BusinessObjects Business Intelligence platform 4.0 ; SAP BusinessObjects Business Intelligence platform 4.1 ; SAP BusinessObjects Business Intelligence platform 4.2 ; SAP BusinessObjects Business Intelligence platform R2 ; SAP BusinessObjects Enterprise XI
Keywords
Sort order special charecters dashes webi , 5011865 , 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 for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview