title

Data Source Views in Multidimensional Models | Microsoft Docs

ms.custom

ms.date

03/06/2017

ms.prod

sql-server-2014

ms.reviewer

ms.technology

analysis-services

ms.topic

conceptual

helpviewer_keywords

data source views [Analysis Services]

data source views [Analysis Services], about data source views

SQL Server Analysis Services, data source views

data source views [Analysis Services], multiple

Analysis Services, data source views

multiple data source views

SSAS, data source views

ms.assetid

4c12376f-4fc2-492b-9a00-93eec34571ed

author

minewiskan

ms.author

owend

manager

craigg

Data Source Views in Multidimensional Models

A data source view (DSV) is an abstraction of a relational data source that becomes the basis of the cubes and dimensions you create in a multidimensional project. The purpose of a DSV is to give you control over the data structures used in your project, and to work independently of the underlying data sources (for example, the ability to rename or concatenate columns without directly modifying the original data source).

You can build multiple data source views in an [!INCLUDEssASnoversion] project or database on one or more data sources, and construct each one to satisfy the requirements for a different solution.

Adding or Removing Tables or Views in a Data Source View (Analysis Services)

Change Properties in a Data Source View (Analysis Services)

Define Logical Relationships in a Data Source View (Analysis Services)

Define Logical Primary Keys in a Data Source View (Analysis Services)

Define Named Calculations in a Data Source View (Analysis Services)

Define Named Queries in a Data Source View (Analysis Services)

Replace a Table or a Named Query in a Data Source View (Analysis Services)

Work with Diagrams in Data Source View Designer (Analysis Services)

Explore Data in a Data Source View (Analysis Services)

Delete a Data Source View (Analysis Services)

Refresh the Schema in a Data Source View (Analysis Services)