Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the first child of the parent of a member.
Syntax
Member_Expression.FirstSibling
Arguments
- Member_Expression
A valid Multidimensional Expressions (MDX) expression that returns a member.
Example
The following query returns the first sibling of fiscal year 2003 in the Fiscal hierarchy, which is Fiscal Year 2002.
SELECT [Date].[Fiscal].[Fiscal Year].&[2003].FirstSibling ON 0
FROM [Adventure Works]
See Also
Reference
Help and Information
Getting SQL Server 2005 Assistance
Change History
| Release | History |
|---|---|
17 July 2006 |
|