Max Month By Quarter

Question

Hi,

I have question about calculate max month on the each quarter form 2016. How can I calcuate this in obiee?

For example I check 2016 year and I want show on analisys each quarter and their max month:

Q1 || Month 03

Q2 || Month 06

Q3 || Month 09

Q4 || Month 12

How create month formule for this?

Or maybe formule for last day for each quarter and then I extract month from date?

Venkata Yaswanth Ramisetty · Answer

Hi,

You can drag the Quarter, Month (make this as MAX(MONTH), and the fact. This should work fine.

FYR..

Regards,

Yaswanth

Sherry George · Answer

Hi,

You could do something like below to get max month by quarter, it ranks month number by quarter and then you can just filter rank 1.

RANK(MONTH("Time"."Date") by "Time"."Quarter")

Thomas Dodds · Answer

What dos your date dimension table look like?  are you using an accumulating fact or a snapshot?  the key to success is there ...