.png){kind=spacer}
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:
- Creating an Analysis Services Project
-
In this task, you create the Analysis Services Tutorial project, based on an Analysis Services template.
- 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.
