A data source view is used to define the specific tables that are retrieved from the data source.
The presentation of those tables and their columns can be changed.
You can define a data source view by using the Data Source View Wizard in SQL Server Data Tools.
Data source view can bring together data from multiple data sources. (Multiple data sources in the Data Source View Designer).
A data source view defines the following:
Data model definition (retrieved from one or more data sources) including the following:
Named queries create a data table with a SQL statement definition (from one or more data sources).
Named calculations are extra table columns made from an expressions.
Expression Example:
FirstName + ' ' + LastName
Create diagrams to reduce the visual clutter when you only want to view a subset of the tables in the data source view.
You can create multiple diagrams that show different subsets of the data source view. Unlike different data source views, different diagrams reference the same schema. Therefore, any changes that you make in one diagram apply to all other diagrams in the data source view. Diagrams are useful when you create multiple cubes within the same solution.