Lesson 1: Defining a Data Source View within an Analysis Services Project
Applies To: SQL Server 2016
Designing a business intelligence application in SQL Server starts with creating an Analysis Services project in SQL Server Data Tools (SSDT). 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 multidimensional model template.
Defining a Data Source
In this task, you specify the AdventureWorksDW2012 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 AdventureWorksDW2012 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.
Compare your results against a sample project file that was built for this lesson. For more information about downloading the sample projects that go with this tutorial, see SSAS Multidimensional Model Projects for SQL Server 2012 on the product samples page on codeplex.
Create an Analysis Services Project (SSDT)
Supported Data Sources (SSAS Multidimensional)
Data Source Views in Multidimensional Models
Analysis Services Tutorial Scenario
Multidimensional Modeling (Adventure Works Tutorial)