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
Is your source Dimensional or Relational?
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).
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).