Words Definition
SSDT:
SQL Server Data Tools
SSAS:
SQL Server Analysis services
Analysis Services project
A project based on an Analysis Services multidimensional model template。
Solution
Includes one or more projects
Project
- A collection of related objects.
- Projects exist within a solution
- A project has one or more data sources
- Project source databases are frequently hosted on one or more remote computers
Data source view
- A single, unified view of the metadata from the specified tables and views that the data source defines in the project.
- Enables to work with the metadata during development without an open connection to any underlying data so