By default Analysis Services returns members in an order specified during
attribute design. Attribute properties that define ordering are
"OrderBy" and "OrderByAttribute". Lets say we want to see
order counts for each year. In Adventure Works MDX query would be:
SELECT {[Measures].[Reseller Order Quantity]} ON 0
, [Date].[Calendar].[Calendar Year].Members ON 1
FROM [Adventure Works];
Same query using TopCount:
SELECT
{[Measures].[Reseller Order Quantity]} ON 0,
TopCount([Date].[Calendar].[Calendar Year].Members,3, [Measures].[Reseller
Order Quantity]) ON 1
FROM [Adventure Works];
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment