Creating a Data Source View (Basic Data Mining Tutorial)


Applies To: SQL Server 2016 Preview

A data source view is built on a data source and defines a subset of the data, which you can then use in your mining structures. You can also use the data source view to add columns, create calculated columns and aggregates, and add named views. By using data source views, you can select the data that relates to your project, establish relationships between tables, and modify the structure of the data, without modifying the original data source. For more information, see Data Source Views in Multidimensional Models.

To create a data source view

  1. In Solution Explorer, right-click Data Source Views, and select New Data Source View.

  2. On the Welcome to the Data Source View Wizard page, click Next.

  3. On the Select a Data Source page, under Relational data sources, select the Adventure Works DW 2012 data source that you created in the last task. Click Next.

    System_CAPS_ICON_note.jpg Note

    If you want to create a data source, right-click Data Sources and then click New Data Source to start the Data Source Wizard.

  4. On the Select Tables and Views page, select the following objects, and then click the right arrow to include them in the new data source view:

    • ProspectiveBuyer (dbo) - table of prospective bike buyers

    • vTargetMail (dbo) - view of historical data about past bike buyers

  5. Click Next.

  6. On the Completing the Wizard page, by default the data source view is named Adventure Works DW 2012. Change the name to Targeted Mailing, and then click Finish.

    The new data source view opens in the Targeted Mailing.dsv [Design] tab.

Creating a Data Source (Basic Data Mining Tutorial)

Lesson 2: Building a Targeted Mailing Structure (Basic Data Mining Tutorial)

Defining a Data Source View (Analysis Services)