[Company Logo Image] 

Home Up Contents Coffee Break Credits Glossary Links Search

Create a Data Source View



Analysis Services
CLR Integration
High Availability
Open Source
SQL Server 2008
SQL Server 2012
SQL Server 2014
SQL Server 2016
SQL Server 2017
SQL Server 2019

Create a Data Source View

Applies to:  SQL Server 2008 RC 0.

The last task that need to be done before creating a cube is creating a Data Source View.

Let's use the Data Source View Wizard for creating this object:

1. On the Solution Explorer, make a right click on the folder named Data Source Views and select "New Data Source View".

2. On the welcome screen shown below click on Next.

3. On the screen below, please select the Data Source we created for the AdventureWorksDW database, and then click on the Next button.

4.  The image below shows the objects you need to include for the data source view.  When finished, click on Next.

6. On the Completing The Wizard page, enter the name of the Data Source View in the Name text box, then click on Finish.




.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.