Syntax

member.NextMember [( layertype ) ]

or

NextMember ( member [,layertype ] )

Parameters

member

The starting member from which .NEXTMEMBER counts one member forward.

layertype

GENERATION or LEVEL. The default is Generation.

Notes

• If the next member is not found, this function returns an empty member. For example, using Sample Basic, these would return an empty member: Qtr4.nextmember and Year.nextmember.

• When multiple hierarchies are enabled, this function returns NULL when the source member is in one hierarchy and the result member belongs to a different hierarchy.

Example 1

The following MDX expression returns [Jul], which is one step further than Jun:

 [Jun].nextmember

Example 2

The following MDX query:

/* 
For January, PrevMember doesn't exist
For December, NextMember doesn't exist
*/

WITH 

MEMBER 
 [Measures].[Delta from Previous Month] 
AS 
 ' [Measures].[Sales] - 
  ([Measures].[Sales],[Year].CurrentMember.PrevMember)
 '

MEMBER [Measures].[Delta from Next Month]
AS
 ' [Measures].[Sales] - 
  ([Measures].[Sales], [Year].CurrentMember.NextMember)
 '

SELECT
 { [Measures].[Sales], 
   [Measures].[Delta from Previous Month], 
   [Measures].[Delta from Next Month] 
 }
ON COLUMNS,

 [Year].Levels(0).Members
ON ROWS

FROM Sample.Basic
WHERE 
 (
  [Scenario].[Actual], 
  [Market].[East], 
  [Product].[100]
 )

returns the following output:

See Also

PrevMember

Lead