1211
Chapter 53: Building Multidimensional Cubes in Analysis Services with MDX
53
FIGURE 53-8
Analysis Services cube designer in solution explorer.Cube Structure
The cube structure view is the primary design surface for defi ning a cube. Along with
the ever-present Solution Explorer and Properties panes, three panes present the cube’s
structure:■ (^) The Data Source View pane, located in the center of the view, shows a chosen por-
tion of the data source view on which you can build the cube. Each table is color-
coded: yellow for fact tables, blue for dimensions, and white for neither. A variety
of options are available by right-clicking a table or the background, including hid-
ing tables, showing tables, and showing related tables. The Measures pane, located
in the upper-left corner of the view, lists all the cube’s measures organized by mea-
sure group.
■ (^) The Dimensions pane, located in the lower-left section of the view, lists all dimen-
sions associated with the cube. Not all dimensions from the project are required to
be in this list, only those needed for the available measure groups.
c53.indd 1211c53.indd 1211 7/31/2012 10:30:24 AM7/31/2012 10:30:24 AM
http://www.it-ebooks.info