Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OBIEE 12c - Watchlist sort order on Score column is alphabetical.

1
Views
3
Comments
Mark.Thompson
Mark.Thompson Rank 6 - Analytics Lead

pic0.jpg

pic0.jpg

Comments

  • Do you see numbers? Not me

    It's known that right after 0 is 100 and all the others come after

  • Mark.Thompson
    Mark.Thompson Rank 6 - Analytics Lead

    Yup, Gianni, I see numbers in the Score column, as shown in the screenshot.  Are you saying that, on your system, you don't see numbers in the Score column?  If so, I don't think I've done anything special to make it happen on mine.  I'm on version 12.2.1.2.0 (Build BIPS-20160923092103 64-bit).  Also, I've assigned scores using the Show Advanced Properties checkbox on the States screen.  Other than that, I can't imagine why you wouldn't see numbers in the Score column.  Weird.

    And you are absolutely correct that 0 is displayed first, then 100, then the others.  My point is that the sort is treating the numeric Score column as char, and therefore it is sorting alphabetically rather than numerically.  The underlying field is numeric -- when entering a Score on the States page, it won't accept anything other than numbers between 0 and 100.  I can't imagine why anyone would think that it is correct to treat those numbers as characters and to sort them alphabetically.  That makes ZERO sense.

  • Sorry @Mark T. , it was a totally not serious comment (because it's Saturday) and it's just totally absurd as thing.

    Scores have always been numbers (actually percentages without the '%' sign), and it's totally dumb that there they are sorted as text.

    Worth opening a SR asking for a fix I would say (maybe there is always something about it).