Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 17 Oracle Analytics Lounge
- 218 Oracle Analytics News
- 44 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 81 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Sorting Hierarchy Columns
Hello Experts
Is there way to sort hierarchical column in OBIEE.
+Total Rev
+Service Rev
Usage Rev
Subs Rev
Other Rev
+ Eqip Rev
Here I want Subs -> Usage -> Other Rev.
Can you pls. suggest.
Answers
-
Did you try setting the "sort order column" in the logical column representing that level of your hierarchy?
Because for a random sort like the one you want there aren't miracles, you have to provide a column which does the sorting ...
0 -
Hi Gianni
Thanks I tried bringing in the hierarchy code columns pertaining to that level and included the sorting by writing the case.. when. But that didn't help in sorting that column.
Also tried including the sort order in the logical column in rpd ... but that didn't help either.
Any more suggestions pls....
0 -
What version are you actually on?
0 -
Hi Christian
it is OBIEE 12C.
0 -
Any suggestion pls.
0 -
I just built an example in my own environment and it works perfectly fine:
This is vanilla. Now I create a fake sort:
Result in attrib column
Result in hierarchical column:
Works. Your config must be wrong.
0
