SQL Server
United States (English) Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
TechNet Library
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
0 out of 3 rated this helpful - Rate this topic

LastChild (MDX)

SQL Server 2005

Updated: 17 July 2006

Returns the last child of a specified member.

Copy 

Member_Expression.LastChild
Member_Expression

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

Example

The following example returns the value for September 2001, which is the last child of the first fiscal quarter of fiscal year 2002.

Copy 
SELECT [Date].[Fiscal].[Fiscal Quarter].[Q1 FY 2002].LastChild 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
|
Site Feedback
© 2013 Microsoft. All rights reserved.