MDX Aggregate

Returns a number that is calculated by aggregating over the cells.   SELECT [Date].[Calendar].[Month].members ON 1 , [Measures].[Order Count] on 0 FROM [Adventure Works];   WITH MEMBER [Date].[Calendar].[First3MonthsCY2013] AS Aggregate( // Year To Date YTD ( [Date].[Calendar].[Month].[March 2013] ) ) SELECT [Date].[Calendar].[First3MonthsCY2013] Read More

MDX ParallelPeriod

Returns a member from a prior period in the same relative position as a specified member. SELECT [Date].[Calendar].[Calendar year].members ON 1 , [Measures].[Order Count] on 0 FROM [Adventure Works] SELECT ParallelPeriod ([Date].[Calendar].[Calendar Year] , 1 , [Date].[Calendar].[Calendar Year].&[2013] ) ON 0, [Measures].[Order Read More

MDX Ascendants

Returns the set of the ascendants of a specified member, including the member itself.   SELECT Measures.[Reseller Order Count] ON COLUMNS, Order( Ascendants( [Sales Territory].[Northwest] ), DESC ) ON ROWS FROM [Adventure Works] ;

MDX Ancestors

Returns the set of all ancestors of a specified member at a specified level or at a specified distance from the member. SELECT { Ancestors([Product].[Product Categories].[Product].[Mountain-100 Silver, 38],[Product].[Product Categories].[Category]), Ancestors([Product].[Product Categories].[Product].[Mountain-100 Silver, 38],[Product].[Product Categories].[Subcategory]), Ancestors([Product].[Product Categories].[Product].[Mountain-100 Silver, 38],[Product].[Product Categories].[Product]) } ON 0, Read More

MDX TOPCOUNT

Sorts a set in descending order and returns the specified number of elements with the highest values. SELECT [Measures].[Reseller Sales Amount] ON 0 , TopCount ( { [Geography].[Geography].[City].Members //* [Date].[calendar].[calendar Year].Members } , 10 , [Measures].[Reseller Sales Amount] ) ON 1 FROM Read More

MDX MEMBERS

If a hierarchy expression is specified, the Members (Set) function returns the set of all members within the specified hierarchy, not including calculated members. To obtain the set of all members, calculated or otherwise, on a hierarchy use theĀ AllMembers (MDX)function. If a Read More