cancel
Showing results for 
Search instead for 
Did you mean: 

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

former_member211289
Participant
0 Kudos

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

jyothirmayee_s
Active Contributor
0 Kudos

Hi,

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

Thanks,

Jothi

former_member211289
Participant
0 Kudos

Hi

012017 is the date format.

Please provide info over difference between 2017.01. or 012017

jyothirmayee_s
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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.

jyothirmayee_s
Active Contributor
0 Kudos

Yes you can.

Try this

=EXTRACT(MONTH FROM tablename.objectname)

Assign variable to number.

Thanks,

Jothi

Accepted Solutions (0)

Answers (1)

Answers (1)

mhmohammed
Active Contributor
0 Kudos

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