This content has been marked as final. Show 4 replies
One single fact table is usually best, just as both answers above suggest. Also, add a flag that has the value 'Actuals' or 'Budget' and use this as dimension.
You can in fact have a mixed granularity in the fact table. See more on: