Specify the Aggregation Function for a Measure
As you move up a hierarchy, a cube browser displays aggregated values. The default aggregation function is Sum, which adds lower level values to get higher level values. With some derived measure expressions, however, you get incorrect values if you use the Sum function to aggregate the values. See what happens when you attempt to calculate and aggregate an average price measure.
1. | Click the Insert Measure toolbar button, and double-click the Sales_Units column. This creates a measure named Sales Units 1. Type Bad Price for the measure’s Name property, and change the value of the Source Column property to “SalesFact”.“Sales_Dollars”/“SalesFact”.“Sales_Units”. This is a derived measure. It uses ... |
Get Microsoft® SQL Server™ 2000 Analysis Services Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
