Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Custom sorting in OBIEE 11g

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.
Answers
-
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.
0 -
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.
0 -
Thanks all, I used the front end, under advance tab, place sorting under Postfix
Thanks!
0