Architecture of Query Execution—Calculating MDX Expressions - Microsoft SQL Server 2008 Analysis Services - page 528

MDSelect

MDAxis
'Columns'

MDAxis
'Rows'

MDWhere From

MDXMember
[Measures].
[Growth]

MDXCube
[Warehouse
And Sales]

MDXMember
(June 1998)

MDX Members

MDXLevel
(Product
Family)

Calculation
Scopes

MDXBinOP
'.'

MDXMember
(Measures].
[Sales Count])

MDXTuple

MDXMember
([Measures].
[Sales Count])

Function
PrevMember

MDAxis
'Columns'

MDXHierarchy
(Time.Time)

FIGURE 29.3

Expression tree—result of the semantic analysis.

not just calculated cells, but all assignment operators, unary operators, custom rollups,
and semi-additive measures), visual totals, key performance indicators (KPIs), and actions.
The Scope object also contains information about the default members for all dimensions
in the cube.

Calculations can have different levels of availability; therefore, there are different types of
scopes:
. Global scope contains calculations defined in MDX scripts, cube metadata objects

such as actions and KPIs, and dimension calculations.

. Session scope contains calculations created by a user in a session (for example, calcu-

lated members created by the CREATE MEMBER statement).

. Query scope contains calculations created in a query using a WITH clause.