The query below returns the last sibling of the parent of Road Bikes from the Product Categories hierarchy in the Product dimension.
|
|
SELECT {} ON COLUMNS,
{[Product].[Product Categories].[Subcategory].[Road Bikes].LastSibling} ON ROWS
FROM [Adventure Works]
|
|
|
|
|
|
|
The query below returns the last sibling for the parent of the member November 2003 in the Calendar hierarchy in the Date dimension. |
|
SELECT {} ON COLUMNS,
{[Date].[Calendar].[Month].[November 2003].LastSibling} ON ROWS
FROM [Adventure Works]
|
|
|
|
|
|
|
The following query returns the last sibling for the parent of the member November 15, 2003 in the Calendar hierarchy in the Date dimension. |
|
SELECT {} ON COLUMNS,
{[Date].[Calendar].[November 15, 2003].LastSibling} ON ROWS
FROM [Adventure Works]
|
|
|
|
|
|
|