Non-aggregating dimensions and AWM

By: Mark Thompson

In AWM, a dimension whose cube aggregation method is listed as "Nonadditive (do not summarize)" will cause the cube to not aggregate along ANY dimension at anything but the leaf levels.

Instead of selecting Nonadditive as the aggregation method, select Sum as the aggregation method, but only apply the aggregation to a hierarchy that has just one level in it. For that purpose, create a dummy level (perhaps called NO_LEVEL), and create a separate single-level hierarchy that includes only that dummy level. Apply that hierarchy as the aggregation hierarchy for that dimension for that cube. The dimension values will not be marked for non-aggregation, and the other "normal" dimensions will then aggregate properly.