Syntax

Member_Expression.NextMember

Return Value

Returns the following member value in the level of the specified member.

Input Parameters

Member_Expression

An MDX expression that returns a member.

Examples

The following example returns the order quantity for 2008, given the specified member 2007.

SELECT
{
  [Order Date Dimension].[Order Date Month Hierarchy].[Order YearMonth].[2007].NextMember
} ON 0 ,
{[Measures].[orderquantity1]} on 1
FROM [Internet Sales Cube]