Partitions and Aggregations
Something that's easy to forget when creating an aggregation design is the impact that partitioning can have on it. Aggregations are only created on a per-partition basis - you can't aggregate across partitions - so that means, for example, when you're partitioning by Month then there's little point building aggregations at granularities higher than Month; after all, if you only have one Month of data in your partition and you aggregate that data to the Month, Quarter or Year levels then the figures for each aggregation will be identical!
Tags: partition, performance, aggregation