Extending data source views

Now that you know how to create a DSV, you are ready to learn how to extend it. In the previous recipe we imported a few tables from a relational data source, but that might not be sufficient to complete your data model. You may need to import objects from multiple data sources, define calculations, or add new data views.

How to do it...

To add or remove objects from the existing DSV, perform the following steps:

  1. Right-click on any blank area within the DSV and choose Add/Remove Tables; this opens the corresponding dialog shown in the following screenshot:
    How to do it...
  2. This screen should look familiar from the previous section when you ...

Get SQL Server Analysis Services 2012 Cube Development Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.