Database Reference
In-Depth Information
Basic aggregation types
Anyone with a passing knowledge of SQL will understand the four basic aggregation
types available when setting the
AggregateFunction
property:
•
Sum
: This is the most common aggregation type to use, probably the one
you'll use for 90 percent of all the measures. It means that the values for
this measure will be summed up.
•
Count
: This is another commonly used property value and aggregates either
by counting the overall number of rows from the fact table that the measure
group is built from (when the
Binding type
property, found on the
Measure
Source
dialog box that appears when you click on the ellipses button next
to the
Source
property of a measure, is set to
Row binding
), or by counting
non-null values from a specific measure column (when the
Binding type
property is set to
Column binding
).
•
MIN
and
MAX
: These return the minimum and maximum measure values.
Search WWH ::
Custom Search