Using Aggregates and the Time Series Functions
Creating aggregate tables
� Time hierarchy: Year level
� Customer hierarchy: State level
3. The last aggregated dimension table is DIM_YEAR_AGG. It only stores YEAR level of data. The parent level of YEAR level is GRAND TOTAL. So there are no other levels that are higher than YEAR level.