Background
In this case study series, we’ve explored how to use age and tally tables to support various forms of banding by denormalizing them into a single dimension table. Each banding, such as age groups or day ranges, is built upon a base level of granularity—ages for age-based dimensions and days for date-based dimensions. These static dimension tables are preloaded and remain unchanged until a future reload is required to support new bandings.
However, some analytical use cases require more flexibility. In particular, users may want to define custom bandings dynamically to explore what-if scenarios. One