Microsoft SQL Server Analysis Services Function Page
Function Name:	LinkMember
Category:	Navigation
Description:	The LinkMember function returns the member equivalent to a supplied member the supplied hierarchy.
Syntax:	LINKMEMBER( «Member>, «Hierarchy» )
Technet Link:	MDX LinkMember Function

The query below returns the July 1, 2002 member from the Fiscal hierarchy in the Date dimension.   WITH       MEMBER [Measures].[UniqName] AS       LINKMEMBER([Date].[July 1, 2002], [Date].[Fiscal]).UniqueName SELECT       {[Measures].[UniqName]} ON COLUMNS       FROM       [Adventure Works]

The query below returns the July 1, 2002 member from the Calendar hierarchy in the Date dimension.   WITH       MEMBER [Measures].[UniqName] AS       LINKMEMBER([Date].[July 1, 2002], [Date].[Calendar]).UniqueName SELECT       {[Measures].[UniqName]} ON COLUMNS       FROM       [Adventure Works]