MDX Function and Operator Reference - Professional SQL Server Analysis Services 2005 with MDX - page 1040

CREATE MEMBER [Time].[MonthsOf2006ToDate] AS
'Aggregate ( {[Time].[Jan 2006] : [Time].[May 2006]}
)'
When combined with a summing measure, this member will yield the sum of
its values over the range of January through May 2006. When combined with
a measure aggregating by MAX, this member will yield the MAX of its values
over that same time period.
In Analysis Services 2000, measures aggregated by DISTINCT
COUNT cannot be aggregated by this function. This is fixed in Ana-
lysis Services 2005.
See also: Sum (), Count (), Min (), Max (), Avg (), DistinctCount ()
dimension .AllMembers
hierarchy .AllMembers Returns: set
level .AllMembers
All return: set
All are extensions: AS2000, AS2005
Generally, the .AllMembers functions are semantically equivalent to Ad-
dCalculatedMembers (Scope.Members), but they provide a more intuitive
syntax. Although the Microsoft documentation only refers to .AllMembers
for dimensions and levels, we note that in the case of multiple hierarchies
on a dimension, you can only use this against one hierarchy.
The only case where .AllMembers and AddCalculatedMembers () differ is
when no members are visible in the scope of [Dimension].Members, [Hi-
erarchy].Members, or [Level].Members. This can occur on the measures
dimension if all measures are hidden in a cube.
The following two statements will generally return the same set:
[Measures].AllMembers
AddCalculatedMembers ([Measures].Members)
See also: AddCalculatedMembers (), StripCalculatedMembers ()