Microsoft Office Tutorials and References
In Depth Information
Loading the Main Table
To complete your analysis, you need to produce a table that contains all the Internet orders
and, for each one, this information:
■ Location of shipment
■ Total weight of the shipment
■ Freight cost
Your final result should look like Figure 10-10.
FIguRE 10-10 The main table needed to perform courier simulation.
As always, you can start with a PivotTable connected to the AdventureWorks OLAP database
to build a report that shows all the lines of each order and, for each line, the product sold, the
freight cost, and the quantity of products. You can accomplish this easily by using a standard
PivotTable connected to the Analysis Services OLAP cube.
Freight cost and location of shipment are pretty easy to get because the OLAP cube lets you
slice by geography and summarize the freight cost. The Internet Order Details dimension lets
you get the information you need at the order level through the Sales Order Number attribute,
as it can be seen in Figure 10-11, where we created a tabular report, ready to be imported to
Unfortunately, in the Internet Sales measure group, you do not have the weight available as
a measure. Weight is instead an attribute of the product dimension, and because it belongs
to a dimension, you cannot summarize it by order number to gather the total weight of an
order, which is your primary parameter of analysis.
Nevertheless, because weight is an attribute of the product dimension, you can rely on the
Show Properties feature of Excel 2010 and make the PivotTable show the freight in the report.
By right-clicking in the PivotTable, in a cell that contains a product description, you can select
the Show Properties In Report menu and then select the check box beside the weight, as you
can see in Figure 10-12.