Analytics Software

Hi,

I need to obtain the value of a metric of a future date. The table I have modeled as a fact has certain metrics as facts for each month (these metrics are already stored physically in the fact table). What i need to do is show the value of December of the current year for each month in the year (its to aid comparison between the actual value of a metric in comparison to the value for December). This "December" value is stored in the month corresponding to December value, so in effect i need to obtain the metric for a future month, the opposite of what the AGO time series function does.

Does anyone know how this is possible. Only way I can think of solving this, is by importing the fact table as new physical table using an SQL SELECT clause as the source, and basically obtaining the fields that act as primary keys of the original fact table as well as the December values for each month of the year. This would then have to be modeled as a new fact table, and since the dimensions would be the same, effectively i could join both fact tables via the dimensions. This would allow mix to obtain in the same report the month, the month value, and the December value for all the months in the year (this is now available in my second fact table).

The only thing is...I cant see this being optimal performance wise...

Any ideas?

Thanks in advance.