If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Rolling 12 month chart

Started by congo, 04 May 2007 06:39:07 AM

Previous topic - Next topic

congo

Hi

I want to create a line chart with a number of different measures; Revenue,  Budgeted Revenue and "Rolling 12 month Revenue" etc. The purpose of the chart is to visualize the trend; how the revenue grew/shrunk over the past years and how the forecast looks like.
My problem is to combine series in the chart with different and shifting timescope. The Revenue and budgeted revenue share the same timescope, IE the month on the x axis, for a certain month the corresponding revenue is used. But for the R12 the timescope is a bit different.
The R12-value of each month should be a calculation of all the revenues from the last 12 months divided with 12, to get an average. Thus the timescope is always shifting.

Have someone done something similar? How was this achieved?
Best regards

MDXpressor

Is your source Dimensional or Relational?
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien

congo

The source data is dimensional.
A star model built up by a fact table and a number of dimensions, where the structure of time dimension looks like: PeriodId(YYYYMM)- Year(YYYY)- Quarter(Q)- Month(MM).


MDXpressor

Sorry, I was actually trying to determine if you were using a Relational Mart, a Dimensionally Modelled Relational Source (DMR), or a true Dimensional Source (Powercube).
No, a proof is a proof. What kind of a proof? It's a proof. A proof is a proof, and when you have a good proof, it's because it's proven.

-Jean Chretien