Creating Your First Multidimensional Cube - Getting Started with SQL Server 2012 Cube Development - page 56

4. Click on OK to save the calculated column.
Now you have a new column in your DimCustomer table that concatenates the first
name with the last name of the customers to create their full name. In order to test
your new column, right-click on the DimCustomer table and choose Explore Data .
As you can see, you now get an Explorer that shows a sample of the rows in the
DimCustomer table. The Explorer view by default shows you the top 5000 rows in a
table but you can also view a sample based on a random sample by clicking on the
Properties button in the top right-hand corner.
Now it is time to change the DimDate table to instead use a query as the source. To
do this, perform the following steps:
1. Right-click on the DimDate table and choose Replace Table | With New
Named Query .
2. In the Create Named Query window, type in the following query: