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 ...
Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
