How to Custom Sort Months in OBIEE 12

User_TSZUE

Hi All,

can you please tell me how to custom sort months in FY order Jul 23 - June 24, in Subject topic Statistic history and forecast.

Thank you in Advance.

kind regards,

Ashwik

User_TSZUE

Thank you Arjun and Gianni for your prompt response.

I am Hotel manager who is using R&A which is linked to Opera cloud and i don't have acces to RPD or other Docs.

I have been trying to do a custom formulae so i can get a new column using formule Case when Month = JAn then 1 but this also a error, can you please provide me with a solution

I am very new to this if you could please drill down your answers so its easy to understand for a beginner.

Kind regards,

Ashwik

Mallikarjuna Kuppauru-Oracle

Hi,

Below is the syntax -

CASE

WHEN ("TableHeading"."ColumnName1"='Value1' ) THEN '1'

WHEN ("TableHeading"."ColumnName2"='Value2' ) THEN '2'

WHEN "TableHeading"."Column Name"='Value3' THEN '3'

ELSE "TableHeading"."Column Name"

END

Regards,

Arjun

User_TSZUE

Hi Arjun,

Thank you Heaps for your help It worked.

Much appreciated!

Kind regards,

Ashwik

Mallikarjuna Kuppauru-Oracle

Hi Ashwik,

Good to see your update. Please accept the answer and close the Thread.

Regards,

Arjun

Mallikarjuna Kuppauru-Oracle

Hi Ashwik,

Thanks for using Oracle Communities.

Are you looking at Prompt level or report level sorting?

Below are the some of the MOS docs -

How To Create Custom Sort For Oracle Analytics Prompt (Doc ID 2936805.1)

OTAC/TEE: How to Sort Character Months Chronologically (Doc ID 2117797.1)

Regards,

Arjun

Gianni Ceresa

In the RPD you generally set a sort column on the logical column you need. It's for example what you do with a column being just the month name to not sort it A-Z, you do set a sort column being the month number and this make the months to take their correct order.

In your case you can do the same, because a fiscal calendar could be very different than the standard calendar, you do set the correct sort column for your months to make them sort the way they must be.

User_LL6E2

Hi. Ive read this thread and just need a little more help on the sorting of the month column into chronological order instead of alphabetical. Arjun provided the below but I assume I am to amend and replace, but how?

My thinking if using January as an example. Is this anywhere near correct?

WHEN ("TableHeading"."Month1"='JAN1' ) THEN '1'

month.png

Below is the syntax -

CASE

WHEN ("TableHeading"."ColumnName1"='Value1' ) THEN '1'

WHEN ("TableHeading"."ColumnName2"='Value2' ) THEN '2'

WHEN "TableHeading"."Column Name"='Value3' THEN '3'

ELSE "TableHeading"."Column Name"