Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Do I need to create 3 fact table in the cube?

Answered Do I need to create 3 fact table in the cube?

  • Wednesday, February 20, 2013 5:00 AM
     
     
    Sign In to Vote
    0

    Hi,

    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




     

All Replies