| 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] |
| |
| |
| |
|
| |
|