First Look at Analysis Services 2005 - Professional SQL Server Analysis Services 2005 with MDX - page 72

Figure 2-34
The cube editor has several panes that allow you to perform various opera-
tions that could be performed on a cube object. Your default pane upon com-
pletion of the cube wizard is the Cube Structure pane. Other panes of the
Cube Editor are Dimension Usage, Calculation, KPIs, Actions, Partitions, Per-
spectives, Translations, and Browser. In this chapter you will become familiar
with basic operations in the Cube Structure and the Browser panes. You learn
more about the Cube Editor in Chapters 6 and 9 .
The Cube Editor pane has been divided into three windows: Measures, Di-
mensions, and the Data Source View. If you need to add or modify Measure
groups or Measures you will do that within the Measures window. The Dimen-
sions window is used to add or modify the dimensions relevant to the current
cube.
The Data Source View shows all the fact and dimension tables used in the
cube with appropriate colors (yellow for fact table and blue for dimension
table). Actions such as zoom in, zoom out, navigation, finding tables, and dif-
ferent diagram layouts of the tables that are possible in the DSV Editor are
available within the DSV of the Cube Editor.
If you right-click within the Measure, Dimension, or Data Source View win-
dows you will be able to see the various actions that could be accomplished
within the windows. The actions within the Measure, Dimension, or DSV win-
dows of a Cube Editor can also be accomplished by clicking the appropriate
icons (see Figure 2-34 ) in the Cube Editor.