Cube Design - Professional SQL Server Analysis Services 2005 with MDX - page 228

Figure 6-10
The Cube Wizard creates the dimension objects and the cube after you hit
the finish button. The created cube Adventure Works DW is opened within the
Cube Designer as shown in Figure 6-11 . The Cube Designer contains several
tabs that help perform specific operations that will refine the initial cube cre-
ated by the Cube Wizard. The default tab is the Cube Structure as shown in
Figure 6-11 . The Cube Structure view you can see three panes that show the
Measures, Dimensions, and the DSV. The DSV contains all the tables that
are part of the cube. Operations such as adding or deleting tables in the DSV
and zooming in or out with the DSV Designer are possible within the cube
DSV. The Dimensions pane shows the dimensions that are part of the current
cube and the Measures pane shows the measure groups and measures that
are part of the current cube. You can add or delete measures and dimensions
in the Cube Structure view. The dimensions within the cube shown in Dimen-
sions pane are called cube dimensions. You can have multiple instances of
the shared dimensions of the database within a cube. For example, the Fact
tables FactInternetSales and FactResellerSales have relationship with the
Dim Time dimension through Order Date, Ship Date and Due Date. Hence
you can see three cube dimensions Ship Date, Due Date and Order Date in
the Dimensions pane which refer to the Dim Time database dimension. A di-
mension such as Dim Time which plays the role of three cube dimensions is