Database Reference
In-Depth Information
Figure 9-22.
Selecting which tables are used in your data source view
SQL views also appear as available objects, which means you can create views in OLTP or data warehouse
databases that can be used as the source of your cubes and dimensions. Using views, you can combine one or
more tables to create what appears to be a single table. This is identical to the scenario shown in Figure
9-18
with one important distinction; the code in a SQL Server view is stored in the SQL database, while the code in
the data source view is stored in an SSAS database. Both have equivalent performance since they are saved SQL
statements after all. The choice is usually based on permissions.
As an SSAS cube developer, you probably cannot create whatever views you want in the data warehouse, but
you can create what you want on SSAS. Therefore, the choice becomes pretty simple. Once you have selected the
tables, click the Next button.
■
The view in Figure
9-22
has not been created as part of the chapter exercises and should not be in
your database. We added it as an example of what
may
exist in a typical data warehouse database.
Important
Completing the Wizard
In the final dialog window (Figure
9-23
), you can name the data source view. A name is suggested for you, but
it does not really matter what you call it as long as it is consistent with other items in the project. You may find
that using a name that describes the purpose and has no spaces between each word is the most convenient and
easiest to work with.
