Content Comparison

Description:

This is a member property function is , used to return a number that is calculated by aggregating over the cells returned by the set expression. If a numeric expression is not provided, this function aggregates each measure within the current query context by using the default aggregation operator that is specified for each measure. If a numeric expression is provided, this function first evaluates, and then sums, the numeric expression for each cell in the specified set.the display value of the mentioend member.

Syntax:

Aggregate(SetMember_Expression [ ,Numeric.caption OR Member_Expression ].PROPERTIES(Caption)

Return Type:
SCALAR

Parameters:

...

Parameter

...

Description

...

Set_Expression

...

...

Numeric_Expression

...

A valid numeric expression is typically an MDX expression of cell coordinates that returns a number.

Example:

WITH MEMBER [Measures].[DCResult] AS     AggregateCAPTION( [CustomerDimensions].[GeographyHierarchy].[Country].&[Australia],
		[Customer].[Geography].[Country].&[Canada]
    )
SELECT  
   CURRENTMEMBER..PROPERTIES(caption)) SELECT [Measures].[DCResult] ON COLUMNS,
    [Product].[Product Categories].Children ON ROWS
FROM
     [AdventureWorksMF0 FROM [CubeName]