The Ascendants functionality gives back all levels from and including the current level.
SELECT
Measures.[Sales Amount] ON COLUMNS,
Order(
Ascendants(
[Product].[Product Categories].[Product].&[448]
),
DESC
) ON ROWS
FROM
[Adventure Works]
where ([Date].[Calendar Year].&[2012])
Will give us:
Have Fun And Till Next Time
No comments:
Post a Comment