Concatenate Month grained fact to Day grained fact

[paul_scotchford]

Hi All

I am looking for an effective way to apply Month grained fact Data to Day grained data ?

Scenario is ...

Month based Sales Budgets to concatenate into a

Day based Sales fact

One obvious answer is to make Daily budget facts and concatenate to the Sales Fact, but this

will misrepresent the shape of the chart as budgets are determined for a Stock Sub Category and

Store.

Currently I concatenate at a Month level and this is fine in a chart where rolling at Month to Year ,

but when drilling to the Week, Day then of course the budget value will be 0.

Has anyone done something like this ?

Many thanks

Paul

[hic]

This is possible and you can read about one way to do it on Fact Table with Mixed Granularity:

HIC

[paul_scotchford]

Thanks Henric, this is very useful.