Skip to Content
author's profile photo Former Member
Former Member

SORT order in BO vs Database that is attached to

Post Author: ROMZILBER

CA Forum: WebIntelligence Reporting

Hello

We have another issue with WEBi reports. When we do sor

Database sorts values this way:

u201CA Cu201D

u201CA Mu201D

u201CAE

u201CAIu201D

Why Business Object does not consider space as a valid character for sorting. So it will sort the same values different way

u201CA Cu201D

u201CAEu201D

u201CAIu201D

u201CA Mu201D

I would appreciate any help on this and the previous issues.

Add a comment
10|10000 characters needed characters exceeded

Related questions

4 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 02:34 PM

    Post Author: jsanzone

    CA Forum: WebIntelligence Reporting

    Are you absolutely sure that there is a space within your data and not some other non-printable character masquerading around as a space? The only way to tell for sure is to use a low-level program that can examine each position within your data and give you the ASCII code for it. For instance ASCII 65 represents "A" and ASCII 32 represents a single space. Chances are something is up with your data that is causing you to question the collating that is taking place...

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2007 at 06:24 PM

    Post Author: ROMZILBER

    CA Forum: WebIntelligence Reporting

    Hello

    When I just run Oracle query it sorts them correctly, so I do not think this is a data issue. We have talk to BO and they said "

    Hi Tim, the behavior you experienced in sorting with space is currently by design. To define the sort you want to accomplish, webi allows you to create a custom sort." but it is kind of pain to do it for every report. I wish you can just change it globally. Does any know of any work around?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 06, 2007 at 07:05 PM

    Post Author: Ranjit

    CA Forum: WebIntelligence Reporting

    Can you sort your report by replace(FIELD, " ", "")

    Ranjit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 14, 2007 at 12:19 AM

    Post Author: ROMZILBER

    CA Forum: WebIntelligence Reporting

    I think what BO does. and this is not what we are looking for

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.