Triplicate Quarterly Data into Monthly Data

[karthik.cognos]

Friends,

I have 2 crosstabs in my RS report. The 1st crosstab has data at a monthly level and the 2nd crosstab has data at a quarterly level...

The requirement is to display both the crosstabs at monthly level, so the 1st crosstab is straight forward...but for the 2nd crosstab, I have data for 03/31, 06/30, 09/30, 12/31...My customer asked me to display the 2nd crosstab at a monthly level too and he said I could triplicate the data, as in I could use March data to populate the measure for Jan and Feb (so all the 3 months would have the same number), use June data to display data for April and May and so on...

Any ideas, how to achieve this?

I reached up to a point where, I did a left outer join to my date dimension and was able to display all the months in the 2nd crosstab and now the challenge is to populate the data for the months Jan, Feb, Apr, May, Jul, Aug......I do have a date prompt on my prompt page with which the user will be able to select the Begin Year & Month and End Year & Month.

Thanks in advance for your help!