Skip to Content
0

Sorting not working in Dimension Filter

Apr 11, 2017 at 08:24 AM

59

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Tammy Powlas
Apr 11, 2017 at 09:15 AM
0
Share
10 |10000 characters needed characters left characters exceeded
Piyush Narayan Apr 11, 2017 at 09:42 AM
0

Hi Tammy,

Unfortunately that is not related to my scenario.

Regards,
Piyush

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

0