Database Reference
In-Depth Information
Columns can be added to a table in the data source view either by adding a new Named Calculation or
by replacing a table completely using a named query. For our example, it is necessary to use a named query,
because we must join data from two tables, and named calculations cannot do this.
You can add members from other tables, and even databases, by replacing the table with a new named
query, as shown in Figure
11-35
.
Figure 11-35.
Adding a derived measure using a named query
■
of course, you must reopen the data source view editor in order to do this. it can be reopened any time by
right-clicking the data source view icon in Solution Explorer and selecting View Designer from the context menu.
Tip
Once you select this option from the context menu, you will be presented with a query designer. You can
either type in the code or let the designer create it for you. Another option is to copy and paste code that has been
created and tested in SQL Server Management Studio, as we have done in Figure
11-36
.
