Export (0) Print
Expand All
This topic has not yet been rated - Rate this topic

Lesson 3: Defining a Data Source View for Your Report Model

After defining the data sources that you will use in your report model project, your next step is to define a data source view for the project. A data source view is a logical data model based on one or more data sources. However, only data source views based on a single data source can be used for report models. Data source views not only encapsulate access to the physical objects, such as tables and views, contained in underlying data sources, but also allow additional annotations, such as definitions for named calculations, named queries, and relationships, to be created and managed outside the underlying data sources. Reporting Services generates the report model from the data source view. In this tutorial, the data source view provides the source information for the model you will generate.

Data source views facilitate the model design process by providing you with a useful representation of the data that you specified. Because metadata is stored in the data source view, you do not need to be connected to the underlying data source to work with the objects. You can rename tables, and fields, as well as add aggregate fields and derived tables, in a data source view without changing the underlying data source. For an efficient model, add only those tables to the data source view that you intend to use.

NoteNote

For the purposes of this tutorial, you will use the data source view that is automatically generated for you. To learn more about manipulating data source views, see Designing Cubes, Defining Data Sources (Analysis Services), and Designing Data Source Views (Analysis Services).

To define a data source view for a report model

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

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

    The Select A Data Source page appears.

  3. In the Relational Data Sources window, verify that the ModelTutorial data source is selected, and then click Next.

    Only one data source can be referenced when creating a data source view for a model project. The Select Tables and Views page appears. On this page, you select the tables from the data source that you want to use in the data source view.

  4. If the Name Matching page appears, accept the default selections and click Next.

  5. In the Available Objects list, select all of the tables.

  6. To add the selected tables to the Included Objects list, click >.

  7. Click Next and then type ModelTutorial in the Name text box.

  8. Click Finish.

    The ModelTutorial.dsv data source view appears in the Data Source Views folder in the ModelTutorial project. The View Designer window appears in Business Intelligence Development Studio displaying the contents of this data source view.

You have successfully created the ModelTutorial data source view containing the metadata for all of the tables from which you will define the initial version of the ModelTutorial project. Next, you will create a report model. See Lesson 4: Defining a Report Model.

Updated Content

Clarified that only data source views based on a single data source can be used with report models.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.