Reg: Month sorting in OBIEE graphs

Question

Hi Team,

As we have graph in below format for diff years (like 2018 to 2020) it was showing like Alphabetical order, we have prompt to select the data, how to sort the graph by moth wise like(Jan, Feb ,Mar… Dec).

Any suggestions we are using version Oracle Business Intelligence 12.2.1.4.0.

Regards,

User_JZKI6 · Answer

Hi Gianni,

Thanks it worked.

Regards,

User_JZKI6 · Answer

Hi Gianni,

Thanks for your reply.

In RPD we don’t have any columns to sort the MMYYYY field, so we can create new column by using case statement and set the numbers for the month year and use that column as sort order column.

Regards,

Gianni Ceresa · Answer

In the RPD you should set the sort order column for your text month logical column. Pick a column which can be sorted correctly for months (like the month number or something like that) and use that one as sort column for the text versions of months.