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!
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!
Hello Ben,
Thank you for your help ! Yours and Adamboer's confirmations are what I was hoping for.
Hopefully it will work 🙂
Best regards,
Pavel