Wednesday, February 20, 2013 5:00 AM
I am trying to create a cube using shipment data.
The situation is that a shipment order have multiple shipment details and multiple special charges.
The main information about the shipment order is saved to the first table including mileage and charge.
The shipment details are saved to the second table including multiple different shipment product information in one shipment order and the weight of each product.
The special charge is saved to the third table including multiple different special charge about one shipement order.Many thanks for your input
Wednesday, February 20, 2013 11:58 AMwe don't know if you need, it depends on what kind of measures you have and what kind of dimensions you have. but you could make it three fact tables and three measure groups, and it is natural to do so.