Databases Reference
In-Depth Information
Designing a Data Source View
A Data Source View (DSV) is an Analysis Services object that represents an abstraction
level on top of a relational database schema. (For detailed information about DSVs, see
Chapter 18.) You might create a DSV that includes only the tables and relationships rele-
vant to your multidimensional model. You can also create named queries and calculated
columns in the DSV so that you can extend the relational schema.
Creating a New Data Source View
To create a new DSV, you use the Data Source View Wizard. When you are in the wizard,
you have to choose a data source. If you need to create a new data source, you can do that
from the Data Source View Wizard—the Data Source View Wizard takes you into the Data
Source Wizard and then returns you to where you came from. (Yes, you are going in
circles. Do not ask.)
NOTE
You can also start with the Data Source View Wizard to create a new data source and
then create a DSV for it.
Launch the Data Source View Wizard
1. In the Solution Explorer, right-click the Data Source Views node to launch the
Data Source View Wizard. Breeze through the Welcome page as usual.
2. On the Select a Data Source page, under Relational Data Sources, select the
data source you want to use a DSV for, and then click Next. If you need to create
a new data source, click New Data Source; doing so takes you to the Data
Source Wizard. Complete the Data Source Wizard. (You can find the steps for this
in the preceding section.) When you finish the Data Source Wizard, it sends you
back to Select a Data Source page of the Data Source View Wizard. Select your
new data source and click Next.
3. If the Data Source View cannot find relationships between tables in the relational
database, go to the Name Matching page, where you will find options for creating
logical relationships by matching columns in the relational database.
4. On the Select Tables and Views page, the available tables and views are listed
under Available Objects. There is another list under Included Objects, blank in the
beginning, of the tables or views included in your DSV. Between the two lists are
two arrows, one pointing left and one pointing right. To add tables or views from
the Available Objects list to the Included Objects list, click the arrow that points
to the right.
You can see the Select Tables and Views page in Figure 9.3.
Search WWH ::
Custom Search