I am using OBIEE 10g.I have time dim and Product fact table.
My requirment is
Above prompt says Year like 2010,2011,2012
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
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