
CHAPTER 29
IN THIS CHAPTER
• Query Execution Stages
• Querying Different Types of
Measure Groups
Architecture of
Query Execution—
Retrieving Data from
Storage
Efficient execution of multidimensional expres-
sions (MDX) requests is the main responsibility of
the formula engine and the storage engine subsys-
tems. In the previous chapter, we discussed the
stages a query passes through the formula engine
and the data structures Analysis Services uses to
calculate the results of MDX queries. In this chapter,
we’ll discuss how Analysis Services retrieves data
from multidimensional storage and how it handles
requests for data stored in different types of parti-
tions ...