Share via

  • Article

How to: Define a Data Source View Using the Data Source View Wizard (Analysis Services)

You use the Data Source View Wizard in Business Intelligence Development Studio to define a data source view in Microsoft SQL Server Analysis Services projects and databases.

To create a data source view

  1. In Business Intelligence Development Studio, open the project or connect to the database in which you want to create a data source view.

  2. To open the Data Source View Wizard by doing one of the following:

    • In Solution Explorer, right-click the Data Source Views folder, and then click New Data Source View.,

    • On the Project menu, click New Data Source View.

  3. On the Welcome to theData Source View Wizard page, click Next.

  4. On the Select a Data Source page, to select a data source, do one of the following:

    • In the Relational data sources list, click an existing data source as the primary data source for the data source view (you can only select one data source in the wizard). The properties of the selected data source appear in the Data source properties pane.

    • Click New Data Source to use the Data Source Wizard to create a new data source and, when complete, return to the Welcome to theData Source View Wizard page to select the newly defined data source. For more information, see How to: Define a Data Source Using the Data Source Wizard (Analysis Services).

    Important

    It is required to set the following Data Source properties to true, in a connection string for all connections to SQL Azure Database: Encrypt, and TrustServerCertificate.

  5. To restrict the schemas that are retrieved from the data source and to indicate whether relationship details should be retrieved, on the Select a Data Source page, click Advanced.

    By default, the schemas are not restricted and relationship details are retrieved. To supply multiple schemas, enter a comma-separated list of schema names in the Restrict to schema(s) box.

  6. In the Advanced Data Source View Options dialog box, click OK or Cancel as appropriate.

  7. Click Next.

  8. If no foreign key relationships are included in the specified relational data source, select the appropriate name matching method on the Name Matching page, and then click Next. For more information about the available name matching methods, see Defining a Data Source View (Analysis Services).

  9. On the Select Tables and Views page, use the arrow buttons (or double-click a table or view) to move tables and views from the Available objects list to the Included objects list.

  10. To include tables related to a table in the Included objects list, select the table in the Included objects list and click Add Related Tables to add tables to the Included objects list that are related to the selected table by a foreign key relationship or a name matching relationship if no foreign relationships existed in the data source.

  11. Optionally, to include system views and tables in the list of available objects, select the Show system objects check box.

  12. Optionally, to apply a filter to the Available objects list, type filter criteria in the Filter box. For example, if you type dbo and click the Filter button, then only those items starting with "dbo" show up in the Available objects list.

  13. Click Next.

    On the Completing the Wizard page, a default data source view name is displayed. You can type a different name, or use the default name, which is the name of the data source for which you are creating the data source view. The Preview pane displays a tree view of the objects in your new data source view.

  14. To complete the wizard, click Finish.

    The new data source view appears in the Data Source Views folder in Solution Explorer.