Defining data source views
Data source view (DSV) serves as a layer of abstraction between a relational data source and SSAS objects. You can import existing tables and views from relational sources into a DSV. DSVs also allow defining new columns and views (named calculations and named queries, respectively) based on the existing structures within your data sources. Let's learn how to create and enhance DSVs.
Getting started
A prerequisite to building a DSV is defining at least one data source. Build a data source before working on DSVs by following a previous recipe.
How to do it...
To define a DSV, perform the following steps:
Right-click on the Data Source Views folder in SSDT's Solution Explorer and choose New Data Source View. This activates the Data Source View Wizard. This wizard allows using the existing data source or defining a new one. If you choose to create a new data source, you will go through the same steps we discussed earlier in this chapter. For this example let's use the...
