Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

Is there any way i can Order a Filter in Oracle Analytics(Oas)

Received Response
297
Views
6
Comments
User_2JH9V
User_2JH9V Rank 1 - Community Starter
in Oracle Business Intelligence Applications

Hi, i´ve been trying to order my 'Year' filter in a descending way. However, i haven´t really been able to achieve this.

I did got the result i wanted in the 'Prepare' Section Tho.

But, when i go to the visualization mode, it just seems like I'm not applying anything.

As you can see there is a new dataset created in the 'Prepare' Section, which should be the one i'm able to see above.

I tried to do this in the OracleBi Admin Tool but i couldn't because i can't do a Select in the expression builder(Not Kidding, i've tried it in different ways but i can't get it to work)

I'm sure there must be another way and i'm just stuck in this 'Basic' task, but i can't really find a solution rn.

I would really appreciate any help or suggestion here, or if it's the case, someone telling me this can't be done(Which i don't really think, but anything can be)

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    Sorry but what version and tool are you using?

    There is a tag "11g", but a screenshot of DV, and then it's about the Admintool : I got lost...

    In the Admin tool you don't write queries, you model things, it's normal that you can't write a SELECT (you can write a select as an opaque view in the physical layer if that's really what you wanted to do).

    In the screenshots I believe I see a subject area, but still I'm not sure to understand what you want to filter and where.

  • User_2JH9V
    User_2JH9V Rank 1 - Community Starter

    Sorry i got a littler carried trying to explain everything i tried.

    This is my Admin Tool.


    And this is where i use the data that i prepare in the admin tool.


    I use the admin tool to prepare my data and then use it in Dv. Not really sure about the tags, is my first post here, apologize again.

    Basically what i'm trying to achieve is not to filter the information.

    What i'm really looking is to sort that filter so i can display the information in a descending way. This case, i'd like to show the years starting with 2022. That´s what i managed to do in the first image in the prepare section, that's what created me the second subject area, but it's the same i'm using for the data.

    Basically what i'm trying to achieve here is a SELECT with an ORDER BY clause for the year filter(Or whatever filter i choose to create, doesn't need to be this one), but i can't manage to do it, regardless if i'm trying it in the Admin tool or in Dv.

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

    Ok so that's OAS 5.9. And why are you creating a data set out of a subject area? SAs are there for direct use. Making a DS out of them is redundant.

    And this is the setting:


  • Gianni Ceresa
    Gianni Ceresa Mod

    Thanks, now I believe I understand your request.

    So you are using OAS 5.9, you have your subject areas coming from the RPD and you use them in DV, all good till here.

    Technically in the RPD you don't sort things, that's why you don't have an attribute on the presentation or logical column to set an ascending or descending sort. The only thing that you could set is to sort based on another column, and this is used mainly for sorting month names: January, February, etc. would be wrong with August first in an alphabetical sorting and that's why it's possible to tell the RPD to sort based on another column which generally is a numeric representation of the month making January 1, February 2 etc.

    Any sorting of data coming from the RPD was to be done in the front end: when building an analysis there were all the sort options in the criteria, when creating a filter it was also possible to sort things if needed etc.

    Taking your example of a "Year" column, the default sorting is ASC, from the smaller to the larger, so 2022 is at the end of the list.

    To be fair I'm not aware of a way to set a default DESC sorting on a column from a subject area, because that's not a feature a subject area (and a presentation column) provides. A way to do it would be, as you did, creating a new dataset and preparing it differently or things like that, but it would not be the subject area itself. Sorting options in DV exists for the visualization, but couldn't find anything for the filter.

    A possible workaround worth trying, is to cheat using the sort based on another column in the RPD (the one I did mention above).

    Create a new column in the RPD being "Year" * -1, add this as "Sort order column" of your "Year" column (no need to add the new column to the subject area, it's only a technical column).

    With some luck DV will respect the feature of "sort order column" and therefore your years will be sorting descending.

    (and of course me writing a lot of bla-bla takes longer than Christian posting the same concept :D )

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

    It's one of those tl;dr days ;)

  • User_2JH9V
    User_2JH9V Rank 1 - Community Starter

    Thank you so soo much, really guys!

    haha of course it takes longer, but to be fair, i'm not sure i would have been able to understand Christian's reply as easily as yours(Gianni).

    I did what you told me, and it does respect the order, both in the technical column and in the colmn filtered by this one.

    Again, thank you guys so much, i really thought i wouldn't be able to pull this one.