Forum Discussion
LBL or Aggregation Upstream
For lifecycle event modelling, Option A (star schema with raw lifecycle data and measures) is preferred approach. Keeping Created Date, Closed Date, and Status at the lowest grain supports changing business requirements and aligns with dimensional modelling.
Measures can then calculate Created, Closed, and Outstanding using Date dimension and filter context.
Consider Option B (pre-aggregated data) only if you are having very large volume, performance requirement and need to standardize calculations across multiple downstream consumers
For lifecycle event modelling, Option A (star schema with raw lifecycle data and measures) is preferred approach. Keeping Created Date, Closed Date, and Status at the lowest grain supports changing business requirements and aligns with dimensional modelling.
Measures can then calculate Created, Closed, and Outstanding using Date dimension and filter context.
Consider Option B (pre-aggregated data) only if you are having very large volume, performance requirement and need to standardize calculations across multiple downstream consumers