Database Reference
In-Depth Information
7. The reason for the inaccurate result is that the static named sets are not eval-
uated at query time. Instead SSAS derives the top three resellers when you
save the calculation. Hence, the same three resellers will be shown regard-
less of query context. To work around this limitation, go back to SSDT and
change the [leading resellers] named set's
Type
to
Dynamic
, and save the
changes.
8. Execute the query shown in step 5 again to confirm that the named set works
as expected, displaying the top three resellers within 2007; here are the res-
ults:
Reseller Sales Amount
Corner Bicycle Supply
$315,833.45
Top Sports Supply
$308,875.49
Metropolitan Equipment
$307,274.84
Search WWH ::
Custom Search