Database Reference
In-Depth Information
Figure 9-24.
The data source view design surface
he Data Source View Designer
In the Data Source View Designer, both SQL Server tables and views are presented as tables. And each table on
the designer surface represents an underlying SQL select statement. For example, the DimStores table represents
the SQL statement
Select StoreKey, StoreId, StoreName From DimStores
. Analysis Server uses these select
statements to copy data into the cube.
The Explore Data Option
You can also run the select statement by using the Explore Data option from the context menu that pops up when
you right-click a table (Figure
9-25
).
