Skip to Content
0

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

Apr 13, 2017 at 09:10 AM

96

avatar image

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

10 |10000 characters needed characters left characters exceeded

Hi,

What your date format in DB (2017.01...) or 012017?.

Thanks,

Jothi

0

Hi

012017 is the date format.

Please provide info over difference between 2017.01. or 012017

0

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

0

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.

0

Yes you can.

Try this

=EXTRACT(MONTH FROM tablename.objectname)

Assign variable to number.

Thanks,

Jothi

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Mahboob Mohammed Apr 17, 2017 at 01:07 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded