5 Replies Latest reply on Aug 3, 2015 7:09 AM by asim cholas

    OBIEE: Sum only if week is already finished

    2999400

      Hi, OBIEE experts.

       

      I have a report requirement where in i will only show/sum the measure if week is already complete, how can i do this in OBIEE?

       

      Another thing is i have to get the number of week/s that is already finished because i will use it to divide the sum of figures (week run rate).

       

      sample

      MONTH
      WEEK1WEEK2WEEK3WEEK4WEEK5
      1234
      5678
      9101112
      13141516

       

      because week 5 is not yet complete, no data is shown.

       

      here's my modified calendar:

          

      MONTH_SDESCWEEK_NUMBER_IN_MONTHDATE_VALUEDAY_OF_WEEK_SDESC
      JUL17/1/2015WED
      7/2/2015THU
      7/3/2015FRI
      7/4/2015SAT
      7/5/2015SUN
      27/6/2015MON
      7/7/2015TUE
      7/8/2015WED
      7/9/2015THU
      7/10/2015FRI
      7/11/2015SAT
      7/12/2015SUN
      37/13/2015MON
      7/14/2015TUE
      7/15/2015WED
      7/16/2015THU
      7/17/2015FRI
      7/18/2015SAT
      7/19/2015SUN
      47/20/2015MON
      7/21/2015TUE
      7/22/2015WED
      7/23/2015THU
      7/24/2015FRI
      7/25/2015SAT
      7/26/2015SUN
      57/27/2015MON
      7/28/2015TUE
      7/29/2015WED
      7/30/2015THU
      7/31/2015FRI