In this exercise, we will create a new calculated column in the DSV for the full name because the customer dimension only contains the first name and last name separately. You will see how we can use T-SQL commands to create a Named Calculation. Perform the following steps to create a Named Calculation.
Go to the Adventure Works DW2012 DSV designer.
In the Customer dimension, you can see that there are three name columns as First name, Middle name, and Last name, but there is no full name. We want to have the full name shown as the main customer attribute of the customer dimension in the cube. So, we will create a column in DSV for that.
Right-click on DimCustomer and select New Named Calculation.
Set the column name as Full Name, and write the following code in the expression area:
FirstName+' '+ISNULL(MiddleName+' ','')+LastName
Click on OK and you will see the new column added to the table. Right-click on DimCustomer and select Explore Data. Some...