Year Format and sort Months

[system]

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

---

zahmed (BOB member since 2018-01-14)

[MarkP]

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.

[system]

Probably will have to make that field a string.

---

kevlray (BOB member since 2010-06-23)