Business Intelligence with MicroStrategy Cookbook

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...

1. Go to Schema Objects | Facts and create a new fact.
2. In the Create New Fact Expression dialog, select FactResellerSales from the Source table dropdown.
3. Drag OrderQuantity from the Available columns list to the Fact expression text area.
4. Very important: set Mapping method ...