Occasionally one sees an entity-relationship diagram (ERD) having an unusual characteristic. The unusual element is an entity (or more than one) that seems to have a relationship with every other ...

When working on a multidimensional design, every fact table within scope should be handled with care. In an ideal world, each low-level fact table represents the metrics related to a business event.