hi
i am a beginner working with Microsoft SQL analysis services
i want a solution to a problem which i cant solve.
i want measure with an aggregate function other than sum,min,max,count
or distinctcount,
like for example avg,
please help me out in this regard

AS 2005 Enterprise Edition allows you use semi-additive aggregation
functions, such as AverageOfChildren:

http://msdn2.microsoft.com/en-us/library/ms189734.aspx
...
Semiadditive Function

Select the aggregation function for the selected measure. The following
table lists the aggregation functions that are available.

Value Description

AverageOfChildren
Aggregated by returning the average of the measure's children.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***