Forum Discussion
Solved
Modeling: Advanced OODB style modeling
We have a number of telemetry sources which have overlap (network traffic at layers 2, 4, and 7) If PowerBI was a OODB (object oriented DB) I would create a class hierarchy for the common Fact Table,...
Hey DoctorYSG ,
I recommend reading the "(The Complete Reference) Star Schema" by Christorpher Adamson. There are fact tables with different dimensionality and dfferent granularity. Different fact tables can share the same dimension.
It is not a good idea to have fact and dimension tables with empty columns if different types of events are measured or different types of business objects are "modeled."
Hopefully, this adds some additional information.
Regards,
Tom
Regards,
Tom
Not if you want/have to use Power BI.
Tom