Reg: Month Chronological Order

User_JZKI6

Hi Everyone,

We have Date timestamp field ‘Service_Date’ 4/22/2020 8:01:00 AM and as per the requirement we converted the format into Apr 2020(changes done in RPD level) and we have data from 2018 to 2020.

In report level data was not showing in month’s chronological order (ex: Jan, feb, mar, Apr…) it was showing in alphabetical order also we have to show chronological order in prompt as well for the same field.

Was there any approach to sort the data in chronological order in report level, we don’t have any month num fields in the table to set the sort order column in RPD level as this is a fact table.

Kindly suggest, version we are using Oracle Business Intelligence 12.2.1.4.0

 Thanks in Advance,

Gianni Ceresa

Sort column is a RPD thing, in the front-end you don't have anything for that.

You have the original date column, use that for sorting. If for whatever reason you can't use that one, just create a new one returning your day in a YYYY-MM-DD HH24:Mi:SS format and even if it's a varchar it can be used as sort column as it does sort correctly.

The question is more why you have a date in a fact table: is it a measure? Not really, so it has nothing to do in the fact table, it should be in a dimension like everything else not being a measure.

User_JZKI6

Hi Gianni,

Thank you for the Responce.

Regards,