Working with Data Sources and Data Source Views - Professional SQL Server Analysis Services 2005 with MDX - page 149

Figure 4-11
In certain instances you might want to create a new column in the table. An
example of this would be to create a Full Name of an Employee from the first
name, middle initial, and last name. One way to accomplish this task would
be to replace the table with a named query and write the appropriate SQL to
create this additional column. However, Analysis Services 2005 provides a
simpler way to do the same operation. Right-click on the Employee table and
select New Named Calculation. This action invokes the Edit Named Calcula-
tion dialog shown in Figure 4-12 . To add a column called Full Name to the
Employee table you just need to combine the first name, middle name, and
last name. You can type the expression for this in the Expression pane as
shown in Figure 4-12 and then click the OK button.