Forum Discussion
2 Fact tables
Anonymous,
It's best to keep fact tables separate instead of merging them. Each fact table should have relationships with dimension tables, resulting in a star schema. Typically, actuals has day grain and forecast has monthly grain. If this is the case with your data, create a calculated column in the forecast table that is a date (use the first day of the month). This will enable you to create a relationship between the forecast table and date table.
Anonymous,
It's best to keep fact tables separate instead of merging them. Each fact table should have relationships with dimension tables, resulting in a star schema. Typically, actuals has day grain and forecast has monthly grain. If this is the case with your data, create a calculated column in the forecast table that is a date (use the first day of the month). This will enable you to create a relationship between the forecast table and date table.