Forum Discussion
Helper IIncome and expense: same or separate fact table?
In my opinion keeping the fact tables separate (and not directly linking between them) is the cleanest approach. Alternatively you could have a single fact table where you add a "fact type" column with the values of "Income" and "Expense" and then use the appropriate filters. But that will get messy quickly with larger datasets, especially when the facts are updated with different cadence.
I think your approach is sound and you should continue with it.
Super UserIn my opinion keeping the fact tables separate (and not directly linking between them) is the cleanest approach. Alternatively you could have a single fact table where you add a "fact type" column with the values of "Income" and "Expense" and then use the appropriate filters. But that will get messy quickly with larger datasets, especially when the facts are updated with different cadence.
I think your approach is sound and you should continue with it.
Helper IThanks for answering lbendlin . I have gone back and forth again a couple of times, and no I am not so afraid of multiple fact tables. I have also decided to add mortage info into my dahsboard. I might be overcomplicating things, but I am getting a better grasp of the logic. Hence my question, would this combination of Fact and Dimensions work? Any ideas to simplify or make the structure better?