Skip to Main Content
Forums

Rolling Months/Qtrs

668566Nov 7 2008 — edited Nov 18 2008
Hi all

i would like to get data for last N no.of months from the FISCAL MONTH(ex: 2008/03) or From the FISCAL QUARTER (ex: 2008 Qtr 4) ,that means if i use prompt and give the 2008/03 it should fetch the last 3 months data (for 2008/01,2008/02 and 2003/03) similarly if i select 2008 Qtr 3 then it should fetch 2008 Qtr 1,2008 Qtr 2,2008 Qtr 3 data.

For this i have to create a prompt.

Please let me know the procedure for this scenario.

Thanks
Ramesh B
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked due to inactivity on Dec 16 2008
Added on Nov 7 2008
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee, #prompt, #report
3 comments
486 views