Several analysis services databases rely on relational schemas, and the Data source view is responsible for defining such schemas (logical model of the schema). Additionally, it can be easily used to create cubes and dimensions, thus enabling users to set their dimensions in an intuitive way. A multidimensional model is incomplete without a DSV. In this way, you are given complete control over the data structures in your project and are able to work independently from the underlying data sources (e.g., changing column names or concatenating columns without directly changing the original data source). Every model must have a DSV, no matter when or how it's created.

Using the Data Source View Wizard to create a DSV

You must run the Data Source View Wizard from Solution EXPLORER within SQL Server Data TOOLS to create the DSV.

• In solution explorer, Right Click Data source view folder -> Click NEW Data Source View.
• Choose one of the available data source objects, or add a new one.
• Click ADVANCED on the same page to specifically select schemas, apply a filter, or exclude information about table relationships.
• Filter Available Objects (If we use a string as a selection criterion, it is possible to prune the list of the available objects).
• A Name Matching page appears if there are no table relationships defined for the relational data source, and you can choose the appropriate method for matching names by CLICKING on it.