on 02-23-2010 6:04 PM
There is a sorting problem with Business Objects such that the sorted results from a database is different from the sorted results within Business Objects (Desktop Intelligence or Web Intelligence).
For example, consider this sample list of last names: Dennis, de Boer, Obbanty, Danson, O Brien, Davis
(NOTE: the space in O Brien)
database results sorted: Danson, Davis, Dennis, O Brien, Obbanty, de Boer
BO results sorted: Danson, Davis, de Boer, Dennis, Obbanty, O Brien
Is there a way to get the saem sorting order as Oracle's ORDER BY clasue in Deski XIR2?
I don't think that will be possible (unless you do a custom sort and place them in the correct sort position manually).
The sort in BusinessObjects is not case-sensitive so a 'd' is the same as 'D'.
Oracle translates the characters to their ASCII value (A=65, a=97, B=66, b=98 etc.) and sorts accordingly.
By default Excel is also case-insensitive when sorting data, but you can set it to case-sensitive using the options when sorting (though that even didn't work for me when I tried it in Excel 2003).
Regards,
Harry
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.