Oracle Analytics and AI

Charles M

Hi.

I am trying to sort a column, in the rpd file, in descending order. The data type of the column is varchar2. Here is a look at it now, from the filter condition:

I would like the last record to appear as first (at the top). For the above example, it would be 'DEC-2016-'.

I can provide additional details to help give a better understanding of what has been don so far.

OBIEE 11.1.1.9.3

Regards,

Charles

Gianni Ceresa

Hi,

In the RPD you don't really define sorting ASC or DESC on columns, they are naturally sorted (so ASC).

Now if you really want you can specify for your column a sorting column, so a different column used to define the sort of your original column.

This is what is generally done for columns with months in a format like "Jan 2017", "Feb 2017" etc. To sort them based on the month you generally set a sorting column having a format like 2017-01, 2017-02 etc.

In your case as you want a descending sorting you will have to provide that kind of column in the data source (so running a ranking function with the required order by clause to force the order you want).

You can also of course simply sort it in analysis etc. but it will need to be done by hand all the time ....