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

Cube Object 1

Global Scope Cache

Hash Key=Role1;Role2 GLOBAL SCOPE

Hash Key=Role3;Role4 GLOBAL SCOPE

Session Object 1

…

Session Scope Cache

Key=Cube1 SessionSCOPE GLOBAL SCOPE

Hash Key=UserName GLOBAL SCOPE

Key=Cube2 SessionSCOPE GLOBAL SCOPE

…

Cube Object 2

Global Scope Cache

Key=CubeN SessionSCOPE GLOBAL SCOPE

Hash Key=Role1;Role2 GLOBAL SCOPE

Hash Key=Role3;Role4 GLOBAL SCOPE

…

Session Object 2

Session Scope Cache

Hash Key=UserName GLOBAL SCOPE

Key=Cube1 SessionSCOPE GLOBAL SCOPE

Key=Cube2 SessionSCOPE GLOBAL SCOPE

Cube Object

…

Global Scope Cache

Hash Key=Role1;Role2 GLOBAL SCOPE

Key=CubeN SessionSCOPE GLOBAL SCOPE

Hash Key=Role3;Role4 GLOBAL SCOPE

…

Hash Key=UserName GLOBAL SCOPE

FIGURE 29.8 The session scope cache contains references to both the session scope and
global scope of a cube.