Database Reference
In-Depth Information
our result by writing a query that does not reference the named set as shown
next. Note that the
Retail Mall
reseller actually shows up in the sixth
spot, it's not one of the top three resellers. Our set should have included
Top
Sports Supply
instead:
SELECT measures.[reseller sales amount]
ON 0,
NONEMPTY(ORDER(reseller.reseller.[all
resellers].children,
measures.[reseller sales amount], DESC))
ON 1
FROM [Adventure Works]
WHERE [Date].[Calendar].[Calendar
Year].&[2007]
Reseller Sales Amount
Corner Bicycle Supply
$315,833.45
Top Sports Supply
$308,875.49
Metropolitan Equipment
$307,274.84
Registered Cycle Store
$296,124.95
Health Spa, Limited
$294,128.38
Retail Mall
$291,364.58
Search WWH ::
Custom Search