Adding Functionality to Your Cube - Getting Started with SQL Server 2012 Cube Development - page 163

6. Click on Next , deselect the DimSalesTerritory table from the Related
Tables dialog, and click on Next .
7. Change the attribute names to Employee and Parent Employee , deselect
the Sales Territory Key attribute, and click on Next .
8. Rename the dimension to Employee and click on Finish .
9. Double-clickonthe Adventure Works DW2012.cube fileinthe Solution Ex-
plorer and click on the Dimension Usage tab.
10. Click on the Add Cube Dimension button and add the Employee dimen-
sion.
11. Process the cube and create a PivotTable with the Employee dimension on
rows and Order Quantity - Fact Reseller Sales as the measure to review
how the new dimension works.