Year Format and sort Months

Hi All ,

I run a dashboard on SAP Universe using Query browser

first i need to format field year to be 2017 , 2018 not 2,017 the data type of the year field is string

second i need to sort the months in Jan , Feb , March order not alphabetic …

month field is datatype string too …

Any Solution
year.JPG


zahmed (BOB member since 2018-01-14)

You’ll need to make changes at the universe level.
There’s more to universe design than simply dragging and dropping source objects.

Format your Year without the comma.


Mark P :uk: (BOB member since 2003-02-03)

Probably will have to make that field a string.


kevlray :us: (BOB member since 2010-06-23)