Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

How to apply sorting order on columns selected in column selector?

Received Response
52
Views
6
Comments
Kari_100683-Oracle
Kari_100683-Oracle Rank 3 - Community Apprentice
edited Aug 13, 2024 5:15PM in Oracle Analytics Forum

I'm using  Obiee 12.2.1.4.0 and for one of my snapshot I've two measure columns in a column selector.

I've to apply Desc sorting based on the column selected and show it in the graph view.

I'm unable to figure out on how this can be done using column selector. Can someone please help?

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    You can't make that automatic. If you have a sort order in the "Criteria" tab then that one wins by default. So if you sort by "Revenue ASC" and then by "Units ASC", this is what will come out. It handles multiple sorting sequentially.

    If you want to the change the sort order on the view - especially after applying a column selector - that means a manual action of right-clicking the newly appeared measure and then "Sort Column" -> "Sort Ascending".

  • Kari_100683-Oracle
    Kari_100683-Oracle Rank 3 - Community Apprentice

    Thanks Christian for your reply. My requirement is to show top 10 data for Revenue in Desc order on one graph and show top 10 data for Units in Desc order on another graph. I can switch between graphs by toggling from one value to another(i.e Revenue/Units). Is there any way to achieve this?

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Create two different views. Sort those views. Then use a view selector. Not a column selector.

  • Kari_100683-Oracle
    Kari_100683-Oracle Rank 3 - Community Apprentice

    I tried creating two different views by using view selector. However, I'm unable to get top 10 records based on different columns(i.e Revenue, Units) through single criteria. I used RCOUNT in criteria tab and it always generates count based on the first sorted column which is Revenue in my case.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Don't sort in the criteria tab. Only sort in the view.

  • Kari_100683-Oracle
    Kari_100683-Oracle Rank 3 - Community Apprentice

    Thanks Christian for the replies.

    I applied sorting in views and applied filter on Rcount<=10 in criteria tab. Still its not taking top 10 rows based on sorting order.

    How the filter should be applied to get top n distinct rows after sorting?