Databases Reference
In-Depth Information
Figure 13-43
After the processing has completed for the Adventure Works cube
send the following MDX query.
select {[Measures].[Sales
Amount],[Measures].[Gross Profit]} on 0,
[Customer].[Customer Geography].members on 1
from [Adventure Works]
You can see the Query events in the SQL Profiler as shown in
Figure
13-44
along with the duration. One of the information that would be
interesting is to notice the subcubes accessed by this query and how
long each subcube query took. The subcubes events indicate the in-
ternal part of the cubes that are utilized to retrieve data from disk.
You can utilize the subcube information to build custom aggrega-
tions. Please refer to download samples of this chapter on building
custom aggregations.
Search WWH ::
Custom Search