Forum Discussion

DoctorYSG's avatar
DoctorYSG
Helper III
2 years ago
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,...
Need Help
  • TomMartens's avatar
    TomMartens
    2 years ago

    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

TomMartens's avatar
TomMartens
Super User
2 years ago

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