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:
   
2. This screen should look familiar from the previous section when you first created the DSV. You could easily add or remove objects to the DSV by clicking on appropriate buttons. One notable difference is the Data source drop-down box. If we had defined multiple data sources, we could import objects into the same DSV using multiple sources. In order to include objects from multiple data sources into a single DSV...