Databases Reference
In-Depth Information
When this dimension is dropped, five new columns are added for the levels defined for specific time
periods (see Figure 5-47).
Figure 5-47
Expand the Measures node and then the Sales Summary folder. Several measures are defined for different
calculations and values. Drag and drop the Sales Amount measure to the rightmost position in the column
list. As soon as you do this, the query design will immediately return dimension and preaggregated mea-
sure values. This is the default behavior of the MDX query builder. For very large databases, it may take
time to return results, especially if dimension members are added in an unusual order. To improve perfor-
mance, you can toggle the Auto Execute mode using the toolbar option indicated in Figure 5-48.
Figure 5-48
Search WWH ::
Custom Search