Data in fact and dimension sources is stored at the lowest level of detail.

Analysis often requires rollup of detailed data

Calculations and aggregation at runtime can be resource intensive.

All of the above