I am creating a dimensional model (data mart) in a data warehouse. I’m running into a design problem involving date resolution. This model will have 2 fact tables: one for actuals, and one for forecast. Actuals in the data source are available at the date resolution of day, whereas forecast in the data source is only available at the date resolution of month. So, I need to express actuals in this mart at the date resolution of month. Actuals are currently saved in another data mart, which means that there is at least potential to re-use that table, but that table is expressed at the date resolution of day, not month. Given that, should I attempt to re-use that table? That is, should I create a view over the actuals table, where I “roll up” date to month? Or, should I create a new actuals table (at the date resolution of month)?