First page Back Continue Last page Overview Graphics
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