cancel
Showing results for 
Search instead for 
Did you mean: 

Calculating month,quarter, year

Former Member
0 Kudos

Hi Experts,

I am creating webi report source as universe. Here i am getting week object from universe. I need to create calculate month, quarter, year using week.

Can anyone suggest me how to do.

Thanks

Anusha.P

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
0 Kudos

HI Anusha,

why don't you create a derived table with aggregates like month and year objects are aggregates derived from fact table.

Former Member
0 Kudos

Hi Anusha,


Are you getting date dimension in your universe?

If yes then you can use following functions to get month,quarter & year

Like

Month = FormatDate([Date];"mmm")

Quarter = if FormatDate([Date];"MM") inList("04";"05";"06") then "Q1" 

else if FormatDate([Date];"MM") inList("07";"08";"09") then "Q2"

else if FormatDate([Date];"MM") inList("10";"11";"12") then "Q3"

else if FormatDate([Date];"MM") inList("01";"02";"03") then "Q4"

Likeyou can get year by using Year function

=Year([Date])

Thanks,

Swapnil

Former Member
0 Kudos

Thanks for your reply swapnil,

Here i am getting weeks from universe i need to calculate month, quarter, year based on the weeks. Suggest me how to calculate in WEBI.

Thanks

Anusha.P

Former Member
0 Kudos

I think if you are getting only week then from that it would be very difficult to calculate year & month.

Are you sure on your universe there is no objects other then week??

Former Member
0 Kudos

yes. I have date and week objects in the week. I need to calculate month and year based on those.

I am getting time stamp with the date object. so i am unable to use the date object.

Thanks

Anusha.P

former_member285534
Active Participant
0 Kudos

Hi Anusha,

¿You need to derive month, quarter & year from week at the webi level?

¿What is your dbms?

¿Could you provide examples of those week values?

Regards,

Fernando