In order to get the max out of the star schema, solutions to common scenarios are shown here.
- Aggregation
- Anonymous Measures
- Combining Facts into one
- Constraints
- Degenerated Dimensions
- Fact Attributes
- Hidden Information
- Hierarchies
- Huge Dimensions
- Keys and their Descriptions
- Null Values
- Preserving History
- Semiadditive and none-additive Measures