Skip Headers
Previous
Previous
 
Next
Next

Create/Edit Cube: Aggregation Rules or Measure Aggregation Rules

Aggregation rules identify the aggregation operators for each dimension of the cube, the order of aggregation, and the hierarchies included in the aggregation. All measures in a compressed cube must use the cube aggregation rules. For uncompressed cubes, you can specify unique aggregation rules for each measure

These options appear only when defining measure aggregation rules:

Choose an aggregation operator for each dimension and specify the order:

Aggregate the cube/measure using selected hierarchies: Select one or more hierarchies for each dimension being aggregated. If you omit a hierarchy, then no aggregate values are stored for it; they are always calculated in response to a query. Because this will degrade runtime performance, you should omit a hierarchy only if it is seldom used.

Related Topics

"When Does Aggregation Order Matter?"

"Aggregation Operators"