Adding more facts
Now we want to complicate things a little more so we need more data: OrderQuantity, TotalProductCost, SalesAmount, TaxAmt, and Freight from FactResellerSales. It is another fact table that we did not include in previous recipes, so we are adding it now.
Getting ready
From the Schema menu, open the Warehouse Catalog window and add the FactResellerSales table from the left list to the right Table being used in the project list. Then click on Save and Close.
How to do it...
Go to Schema Objects | Facts and create a new fact.
In the Create New Fact Expression dialog, select FactResellerSales from the Source table dropdown.
Drag OrderQuantity from the Available columns list to the Fact expression text area.
Very important: set Mapping method to Manual and click on OK.
In the Fact Editor, check FactResellerSales in the Source tables list.
Click on Save and Close and name it
OrderQuantity from FactResellerSales.Repeat steps 1 to 6 and create similar facts with the following columns:
TotalProductCost...
