Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Oct 10, 2005

Introduction to MSSQL Server Analysis Services: Introducing Data Source Views - Page 6

By William Pearson

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.

Click for larger image

Illustration 25: Data Source View Designer Display: Adventure Works DW.dsv

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




Diagram Organizer

Allows creation of "subdiagrams" to allow us to view subsets of the Data Source View


Tables Pane

Tree view display of the tables and their schema elements are displayed


Diagram Pane

Graphic representation of the tables and their relationships


Data Source View Toolbar

A toolbar that is specific to Data Source View Designer


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.


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.

MS SQL Archives

Latest Forum Threads
MS SQL Forum
Topic By Replies Updated
SQL 2005: SSIS: Error using SQL Server credentials poverty 3 August 17th, 07:43 AM
Need help changing table contents nkawtg 1 August 17th, 03:02 AM
SQL Server Memory confifuration bhosalenarayan 2 August 14th, 05:33 AM
SQL Server Primary Key and a Unique Key katty.jonh 2 July 25th, 10:36 AM