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

ShipDateKey DateKey

Note

The reason why the relationships have to be created manually is that
DimDate is query-bound and not bound directly to the DimDate table.

5. Now that the relations have been added it is time to create the Reseller Sales
dimension. Right-click on the Dimensions folder in the Solution Explorer
and choose Add dimension .
6. Select the Use an existing table option and click on Next .
7. Select DimReseller as the main table, ResellerKey as the key column,
ResellerName as the name column, and then click on Next .
8. Click on the Reseller Key attribute and rename it to Reseller Name . Add
the Business Type and Geography Key as attributes and click on Next .
9. Change the name of the new dimension to Reseller and click on Finish .
10. Now you can create the new measure group. In the Solution Explorer ,
double-click on the Adventure Works DW2012.cube cube. In the Cube
Structure tab, click on the New Measure Group button to create the new
measure group.
11. Select the FactResellerSales table as the new measure group table and
click on OK .
12. Change the format string of the newly created measures to match the follow-
ing:

Measure name Format string

Order Quantity - Fact Reseller Sales #,##0;-#,##0