Simple Report Report 13.1
Fully-Additive Measures stored and aggregated in SQL statement Body rows
Non-Additive Measures components are fully-additive; calc in the same SQL statement or in the application
Summary Rows Report 13.2
One dimension - Total
Multiple dimensions multiple levels of
aggregation
Sub-Totals and Total
Non-additive measures always take the ratio of the
sums of the additive components, not the sum
of the ratios (Margin %)
Recall Chap 3 - Storing Margin Dollars vs. calc Margin Dollars computation of summary rows for a non-additive
measure requires access to its fully
additive components, even if they will
not be displayed