Lesson 1: Defining a Data Source View within an Analysis Services Project

Designing a business intelligence application in Microsoft SQL Server 2005 starts with creating a Microsoft SQL Server 2005 Analysis Services (SSAS) project in Business Intelligence Development Studio. Within this project, you define all the elements of your solution, starting with a data source view.

This lesson contains the following tasks:

  • Defining a Data Source
    In this task, you define the AdventureWorks DW database as the data source for the Analysis Services dimensions and cubes that you will define in subsequent lessons.
  • Defining a Data Source View
    In this task, you define a single unified view of the metadata from selected tables in the AdventureWorks DW database.
  • Modifying Default Table Names
    In this task, you modify table names in the data source view, so that the names of subsequent Analysis Services objects that you define will be more user-friendly.

Next Lesson

Lesson 2: Defining and Deploying a Cube

See Also


Analysis Services Tutorial Scenario
SQL Server 2005 Analysis Services Tutorial

Other Resources

Defining an Analysis Services Project
Working with Data Sources (Analysis Services)
Working with Data Source Views (Analysis Services)

Help and Information

Getting SQL Server 2005 Assistance