10. Select View --> Zoom from the main menu in the development environment.
11. Select 50% from the cascading menu that appears, as shown in Illustration 24.
Illustration 24: Select View --> Zoom --> 50% ...
Our Data Source View appears, in somewhat compacted fashion, in the Data Source View Designer as depicted in Illustration 25.
One of several designers within the Studio, the Data Source View Designer for our new Data Source View contains the elements detailed in Table 1 (keyed to Illustration 25 above).
|
Legend Key |
Element |
Purpose |
|
1 |
Diagram Organizer |
Allows creation of "subdiagrams" to allow us to view subsets of the Data Source View |
|
2 |
Tables Pane |
Tree view display of the tables and their schema elements are displayed |
|
3 |
Diagram Pane |
Graphic representation of the tables and their relationships |
|
4 |
Data Source View Toolbar |
A toolbar that is specific to Data Source View Designer |
|
5 |
Data Source View Menu |
A menu that is specific to Data Source View Designer |
Table 1: Data Source View Member Elements
We can add tables to our Data Source View (and perform numerous other activities) at any time by right-clicking the Diagram pane, and then clicking Add/Remove Tables, as shown in Illustration 26.
Illustration 26: Adding Tables to the Data Source View ... and More ...
We can perform many further operations within the Data Source View, the powerful advantages of which should be apparent to those of us who have implemented MSSQL Server Analysis Services 2000 and other OLAP solutions. As our series progresses we will return to the Data Source View to demonstrate many tips and techniques with regard to leveraging this new design paradigm.
1. Select File --> Save All to save our work to this point.
2. Select File --> Exit, to close the Business Intelligence Development Studio and Visual Studio, when ready.
Conclusion
In this article, we examined the Data Source View, a significant enhancement underlying the new Analysis Services development paradigm. We introduced the Analysis Services 2005 concept of Data Source Views, discussing the nature and purpose of Data Source Views, and the Data Sources that support them, within the context of the Business Intelligence Development Studio. We emphasized that an understanding of Data Source Views is critical to any development project in Analysis Services, and discussed how it represents an advance in the modeling, design and creation of sophisticated sources for multi-dimensional analysis.
We undertook a practice exercise whereby we created a Data Source View, for which we initially prepared by creating a new Analysis Service Project; we defined a supporting Data Source, and then created our Data Source View. We then introduced the Data Source View Designer, describing its elements and looking forward to articles where we expand upon its many uses.
» See All Articles by Columnist William E. Pearson, III
Discuss this article in the MSSQL Server 2000 Analysis Services and MDX Topics Forum.
» 
Comment and Contribute
