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

Figure 2-24
The Diagram view in the DSV arranges the tables to best fit within the view.
Sometimes the number of tables in the DSV can be quite large. In such cir-
cumstances navigating to the tables in the Diagram view can be difficult. For
easier navigation you can use the Locator window (see Figure 2-24 ). The
Locator window shows the full DSV diagram as a thumbnail. You can open it
by performing a left mouse click on the 4-headed arrow in the lower-right
corner of the diagram, as highlighted in Figure 2-23 . The Locator window re-
mains open while the mouse button is held down. This allows you to navigate
through the visible area in the diagram view by moving the mouse.
You have now learned the basic operations used within a data source view.
Next, you move on to create the cube using cube wizard.
Create a Cube Using the Cube Wizard
In Analysis Services 2005 you can build cubes via two approaches — top-
down or bottom-up. The traditional way of building cubes is bottom-up by
building cubes from existing relational databases. In the bottom-up approach
you need a data source view from which a cube can be built. Different cubes
within a project can be built from a single DSV or from different DSVs. In the
top-down approach you create the cube and then generate the relational
schema based on the cube design.