February 19, 2003 02:19 PM
Alternative Aggregations
Creatively calculate measure values by using nontraditional methods
Rating:

(0)
SQL Server Magazine
InstantDoc ID #37707
When people think of the structure of an OLAP cube, they usually think of a group of hierarchical dimensions and a set of measures that use summation to determine the measures' values. Often, cubes include measures that are aggregated by using a summation. A variety of other aggregation types exist, but Analysis Services doesn't natively support all of them. A classic example of nontraditional aggregation is inventory analysis. When you analyze inventory, you don't want to determine the quarterl...
...This article is for paid Professional Members only.
Already a Professional Member? Please log in now: