Skip to Content

How to create customized month name object(Sort) in universe level ?

Hi All,

End user asked me to create a customized month name object (Sort) in universe level, so that if they drag that object into webI report level, it should display below data.

Month name::

January

Feb

.......

December.

The reason behind it's for adhoc reporting purposes for users and they don't want to sort the month names in report level.

Please do the needful.

Thanks

Ram

Add comment
10|10000 characters needed characters exceeded

  • There is no difference. just that sorting would be easy if you have month number within the year.

    Usually if the user drag and drop Fiscal Period/Year Key, they should see the months starting from 012017,022017..so on.

    You can always do a custom sort at universe too.

    Try creating a dimension with the formula as

    Select MonthName from DimTime
     Order by MonthNumber

    Thanks,

    Jothi

  • HI Jyothirmayee,

    Is it possible to write a query in UDT dimension? I do not think we can have a order by in the dimension query. Correct me if I am wrong.

    The date format is DD-MM-YYYY.

    Thanks,

    Sai.

  • Yes you can.

    Try this

    =EXTRACT(MONTH FROM tablename.objectname)

    Assign variable to number.

    Thanks,

    Jothi

  • Get RSS Feed

1 Answer

  • Apr 17, 2017 at 01:07 PM

    Hi Ram,

    I've responded to your other question about sorting month names in Webi. I hope SAP is working on a feature to sort month names automatically in a Webi report, Tableau does it automatically. Checkout if there is an idea on SAP Idea Place, and vote up on it. If not, create one, if you've time.

    Thanks,
    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded