title | description | ms.date | ms.service | ms.custom | ms.topic | ms.author | ms.reviewer | author |
---|---|---|---|---|---|---|---|---|
Lesson 1: Defining a Data Source View within an Analysis Services Project | Microsoft Docs |
An overview of defining a data source view for an Analysis Services project. |
04/20/2022 |
analysis-services |
multidimensional-models |
tutorial |
kfollis |
kfollis |
kfollis |
[!INCLUDEappliesto-sqlas]
Designing a business intelligence application in [!INCLUDEssNoVersion] starts with creating an [!INCLUDEssASnoversion] project in [!INCLUDEssBIDevStudioFull]. 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 [!INCLUDEssASnoversion] Tutorial project, based on an [!INCLUDEssASnoversion] multidimensional model template.
Defining a Data Source
In this task, you specify the AdventureWorksDW database as the data source for the [!INCLUDEssASnoversion] dimensions and cubes that you 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 AdventureWorksDW database.
Modifying Default Table Names
In this task, you modify table names in the data source view, so that the names of subsequent [!INCLUDEssASnoversion] objects that you define are more user-friendly.
Lesson 2: Defining and Deploying a Cube