Rolling 12-month measure in WebI

building reports webintelligence
1

Hi All:

I have requirement as follows:

Report have two parameters

Month from: Jan 2009
Month to: Sep 2009

Report should display in the following way:

Month # Rolling Inventory Value (value for current month and previous 11 months)
Jan 2009 Value from Feb 2008 thru Jan2009
Feb 2009 Value from Mar 2008 thru Feb 2009
Mar 2009 Value from Apr 2008 thru Mar 2009
Apr 2009 Value from May 2008 thru Apr 2009
May 2009 Value from Jun 2008 thru May 2009
Jun 2009 Value from Jul 2008 thru Jun 2009
Jul 2009 Value from Aug 2008 thru Jul 2009
Aug 2009 Value from Sep 2008 thru Aug 2009
Sep 2009 Value from Oct 2008 thru Sep 2009

Any idea or a solution as to how this can be implemeted in a WebI report? Remember this is not same as Running Avg.

Regards
Chandra Sekhar

vasanth (BOB member since 2008-06-05)

2

So are you saying that your report query is only returning 9 months of data (Jan '09 through Sep '09), but that you still want a rolling 12 months of data all the way back to Feb '08?

Wouldn’t you need to return data from Feb '08 through Sep '09 to begin with, or am I misunderstanding?

JohnCW :us: (BOB member since 2004-08-05)