Custom sorting in OBIEE 11g

deahayes

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.

Robert Angel

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

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

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

Thanks!