Custom sorting in OBIEE 11g — Oracle Analytics

Oracle Analytics Cloud and Server

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

Custom sorting in OBIEE 11g

Received Response
32
Views
3
Comments
deahayes
deahayes Rank 4 - Community Specialist

Hello all ,

Im trying to do the following under the advance tab, sql issued, but for some reason its not taking it or giving me an error as to why, what am I doing wrong or is there another place I can customize the sorting? It works fine on the server.

sort.jpg

Answers

  • Robert Angel
    Robert Angel Rank 8 - Analytics Strategist

    Hi,

    put your case statement in a formula in the front end, make it the first column, apply sort descending, hide the column. You don't need to hack the XML for this.

    If I had to hack, I would hack the SQL for this, and reference the columns explicitly not via the aliases.

  • Joel
    Joel Rank 8 - Analytics Strategist

    Why aren’t you using the front end to build your analysis? If you must do it this way, replace your aliases saw_0 etc with the actual column names.

  • deahayes
    deahayes Rank 4 - Community Specialist

    Thanks all,  I used the front end, under advance tab, place sorting under Postfix

    Thanks!