A cube brings the elements of the design process together and exposes them to the user, combining data sources, data source views, dimensions, measures, and calculations in a single container. A cube can contain data (measures) from many fact tables organized into measure groups.
Using the Cube Wizard has been covered in earlier sections, both from the top-down approach (see “Analysis Services Quick Start”) and from the bottom-up approach (see “Creating a Cube”). After you create the cube structure, you can refine it using the Cube Designer.
Open any cube from the Solution Explorer to use the Cube Designer, as shown in Figure 53.8. The Cube Designer presents information in several tabbed views described in the remainder of this section.
The cube structure view is the primary design surface for defining a cube. Along with the ever-present Solution Explorer and Properties panes, three panes present the cube's structure: