Moving Months

[lbzh]

We are designing a report where we would like the data to be reported on different moving month options.

A dropdown would be placed on the report where the customer will select either a 1 month, 3 month, 6 month or 12 month Moving Total.

For example when the customer chooses 1 month (assuming report run during August 2008), the result appears as below:

Month       Product count   Market Count
July 2008   35                  12

When the customer chooses 3 month the results appears as below:

Month      Product Count  Market Count
May 2008  45                 8
June 2008  44                15
July  2008  35                12

In the examples above there would be 2 independent dates to do the counting namely Product date and Market date which exist in a dimension. We would somehow need to compare Product and Market date against the request moving month(s) and achieve the counts.

What is the best approach from a Framework Manager and Report Studio standpoint to achieve this type of report with the capability of doing counts at varying moving month periods?

Thank you..