Home Library Learn Samples Downloads Support Community Forums
MSDN Library
Servers and Enterprise Development
SQL Server
SQL Server 2005
Product Documentation
SQL Server 2005 Documentation
SQL Server 2005 Books Online
SQL Server Language Reference
Multidimensional Expressions (MDX) Reference
MDX Language Reference
MDX Function Reference
AddCalculatedMembers
Aggregate
AllMembers
Ancestor
Ancestors
Ascendants
Avg
Axis
BottomCount
BottomPercent
BottomSum
CalculationCurrentPass
CalculationPassValue
Children
ClosingPeriod
CoalesceEmpty
Correlation
Count (Dimension)
Count (Hierarchy Levels)
Count (Set)
Count (Tuple)
Cousin
Covariance
CovarianceN
Crossjoin
Current
CurrentMember
CurrentOrdinal
CustomData
DataMember
DefaultMember
Descendants
Dimension
Dimensions
Distinct
DistinctCount
DrilldownLevel
DrilldownLevelBottom
DrilldownLevelTop
DrilldownMember
DrilldownMemberBottom
DrilldownMemberTop
DrillupLevel
DrillupMember
Error
Except
Exists
Extract
Filter
FirstChild
FirstSibling
Generate
Head
Hierarchize
Hierarchy
IIf
Intersect
IsAncestor
IsEmpty
IsGeneration
IsLeaf
IsSibling
Item (Member)
Item (Tuple)
KPIGoal
KPIStatus
KPITrend
KPIWeight
KPICurrentTimeMember
KPIValue
Lag
LastChild
LastPeriods
LastSibling
Lead
Leaves
Level
Levels
LinkMember
LinRegIntercept
LinRegPoint
LinRegR2
LinRegSlope
LinRegVariance
LookupCube
Max
MeasureGroupMeasures
Median
Members (Set)
Members (String)
MemberToStr
MemberValue
Min
Mtd
Name
NameToSet
NextMember
NonEmpty
NonEmptyCrossjoin
OpeningPeriod
Order
Ordinal
ParallelPeriod
Parent
PeriodsToDate
Predict
PrevMember
Properties
Qtd
Rank
RollupChildren
Root
SetToArray
SetToStr
Siblings
Stddev
StddevP
Stdev
StdevP
StripCalculatedMembers
StrToMember
StrToSet
StrToTuple
StrToValue
Subset
Sum
Tail
This
ToggleDrillState
TopCount
TopPercent
TopSum
TupleToStr
Union
UniqueName
UnknownMember
Unorder
UserName
ValidMeasure
Value
Var
Variance
VarianceP
VarP
VisualTotals
Wtd
Ytd
Expand Minimize
This topic has not yet been rated - Rate this topic

NextMember (MDX)

SQL Server 2005

Updated: 17 July 2006

Returns the next member in the level that contains a specified member.

Copy 

Member_Expression.NextMember
Member_Expression

A valid Multidimensional Expressions (MDX) expression that returns a member.

The NextMember function returns the next member, in the same level, that contains the specified member.

Example

The following example returns the August 2001 member as the next member to the July 2001 member.

Copy 
SELECT [Date].[Calendar].[Month].[July 2001].NextMember ON 0
FROM [Adventure Works]

Release History

17 July 2006

Changed content:
  • Updated syntax and arguments to improve clarity.
  • Added updated examples.
Did you find this helpful?
(1500 characters remaining)

Community Additions

ADD
© 2013 Microsoft. All rights reserved.
|
Site Feedback
© 2013 Microsoft. All rights reserved.