2 Replies Latest reply: Nov 20, 2012 8:36 AM by Maqs-Oracle RSS

    Month Between Fn

    970365
      Hi All,

      I am using OBIEE 10g.I have time dim and Product fact table.

      My requirment is
      Prompt
      Year;Month;month(Duration)

      Above prompt says Year like 2010,2011,2012
      Month:1,2,3,4,5,6,7,8,9,10,11,12
      Duration: user enter values,like 2 or 3 or 4 or.....

      First user selecting Year=2012 then Month=4 then Duration=4 (duration 4 means month of Apr-2012 into Aug-2012--added 4 month from user selection month)

      Then i created one report based on measure values.In that report i set year is prompt and month also is prompt.
      After How can Set duration filter?My requirment is when user selecting duration=4 then report should be display based on Month and Duration values

      My report should be below
      Year,Month,Amount
      2012,4,1000
      2012,5,2000
      2012,6.2000
      2012,7.3000

      Only problem How to implement DURATION filter

      Thanks
      GRam.
        • 1. Re: Month Between Fn
          Srini VEERAVALLI
          Use Presentation variables for Month and duration
          In the report on the month column->Filter icon->
          Advanced->Convert this filter to SQL
          Month between 'selected month' and 'duration'
          OR =month or <duration

          Pls mark if helps
          • 2. Re: Month Between Fn
            Maqs-Oracle
            Hi,

            Capture Month in a presentation variable say Pv_Month and duration in another presentation variable Pv_Duration

            then filter the report as

            Month is greater than or equal to @{Pv_Month}{1}
            Month is less than equal to (@{Pv_Month}{1} + @{Pv_Duration}{4})


            Thanks