Database Reference
In-Depth Information
Figure 9-18.
Data source views represent a logical collection of one or more tables.
The Data Source View Wizard
A data source view is created by right-clicking the Data Source Views folder in Solution Explorer and choosing
New Data Source View from the context menu (Figure
9-19
). This choice starts a wizard that walks you through
the creation process.
Figure 9-19.
Adding a new data source view to the project
Select a Data Source
The data source wizard asks you to select an SSAS data source. You can choose only one data source during
the wizard, but you are able to add additional data sources to the data source view after the wizard completes.
This unusual feature allows you to connect to tables from multiple databases, which can occasionally useful on
occasion, but a single connection is sufficient for most needs. In our example, we chose the DWPubsSales data
source we created earlier (Figure
9-20
).
