Forum Discussion
Same Dimensions, multiple Fact tables, different measures, millions of rows
Hello, I've been creating/updating/enhansing reports for years, even played a bit with dimensional modeling on very simple cases ( up to 10k rows), but in terms of real dimensional modeling with lot...
I think you've got exactly the right idea! Give it a go. Every data model is different but for example a normal pattern I use in education has a number of fact tables will shared dimensions:
We often use measures that require calculations from more than one table!
There are several ways of doing this. Have a look at the five most common: