Sorting not working in Dimension Filter

[former_member413809]

Hi All,

I am using Universe as the source based on HANA.
I want to sort months according to financial year and use that in Dimension Filter.
By default Month object was coming in random order so I created an object in the universe as

Case

When Month='APR' Then 1

When Month='MAY' Then 2

.

.

When Month='MAR' Then 12

End

I sorted the Month using this object,

Now this Month object is sorted when I see that in the Initial View but in dashboard it is not.

Screenshots attached.

Any inputs will be appreciated.

sortingdashboard.pngsorting-initialview.png

Regards,
Piyush

[former_member413809]

Hi Tammy,

Unfortunately that is not related to my scenario.

Regards,
Piyush

[TammyPowlas]

Piyush - I recommend searching for your question, as this has been asked before - see also https://answers.sap.com/questions/138603/prompt-sorting-as-specified-in-universes-lov-lost.html

[TammyPowlas]

Hello - similar questions have been asked before - please see https://archive.sap.com/discussions/thread/3670446 (with Karol's replies) and this blog: https://blogs.sap.com/2014/05/29/how-to-create-multiple-dropdown-boxes-cascading-filters-when-using-...