Multidimensional Models and Business Intelligence Development Studio - Microsoft SQL Server 2008 Analysis Services - page 113

. You can use that same menu to create a named query that will appear as a new table

in the DSV. (Select New Named Query.)

. To create a new named calculation, which will appear as a new column in a table,

right-click the table and select New Named Calculation from the resulting menu.

Editing a Named Calculation
You can edit the properties of a named calculation in the Edit Named Calculation dialog
box. You can reach that dialog box by double-clicking the column that represents the
named calculation. The dialog box already contains values for each property; you can
change any or all of them.

In Figure 9.5, you can see the Edit Named Calculation dialog box that displays when you
double-click the WeekOfYear column in the time_by_day table.

FIGURE 9.5

Use the Edit Named Calculation dialog box to change the properties of a named

calculation.

Designing a Dimension

After you have created your DSV, you are ready to start creating the dimensions for your
multidimensional model. For details about dimensions, see Chapter 5, “Dimensions in the
Conceptual Model.”