Entity Notes

• self.level implies a hierarchy

• • Goal – Objective – Project – Task

• You may not always have a single hierarchy

• • Marketing's product families don't match up with Finance's view of the products

• self.fact is part of the Inverted Database design pattern

• • Normal: Each fact is has foreign keys for an Entity in each Dimension
  • Inverted: Each Entity is associated with a collection of facts