Re: Different Aggregation Functions by Dimension

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hi Emiliano,

If you use AS 2005 Enterprise Edition, there are some semi-additive
aggregation functions that may meet you needs:

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.

ByAccount
Aggregated by the aggregation function associated with the specified
account type of an attribute in an account dimension.

Count
Aggregated using the Count function.

DistinctCount
Aggregated using the DistinctCount function.

FirstChild
Aggregated by returning the measure's first child member.

FirstNonEmpty
Aggregated by returning the measure's first nonempty member.

LastChild
Aggregated by returning the measure's last child member.

LastNonEmpty
Aggregated by returning the measure's last nonempty member.
...



- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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