Database Reference
In-Depth Information
There's more...
The following table lists the most commonly used measure properties:
Measure property
Explanation
Aggregation Function This function determines how measure values are sup-
posed to be aggregated from the bottom-level (also known
as
leaf level
) to the top-level of each hierarchy. SSAS sup-
ports
additive
,
semi-additive
, and
non-additive
aggregate
functions. The semi-additive functions require a time di-
mension (the dimension's type property must be set to
"time"). Such measures can only be aggregated across
the time dimension. The non-additive measures cannot be
Search WWH ::
Custom Search