Forum Discussion

RSSapre's avatar
RSSapre
Frequent Visitor
4 years ago
Solved

Data Model Question - Sales Order Line and Shipment Details

I need some help to model my order management data. I have some dimensions such as customer (sold to, ship to, bill to), product, orgaization and Caledar with 2 fact tables Sales Order Line details ...
Data model
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi  RSSapre ,

     

    Sorry for the late reply.

    How do you connect DimSalesOrderLine and ShipmentDetails?I didnt find the table DimSalesOrderLine in above screenshot.

    Why you create so many dim tables?

    I'm not sure whether it's the problem,but I would suggest you change the relationship I marked in red from both to single.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

RSSapre's avatar
RSSapre
Frequent Visitor
4 years ago

 

Please note that this is not a final model

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    4 years ago

    Hi  RSSapre ,

     

    Sorry for the late reply.

    How do you connect DimSalesOrderLine and ShipmentDetails?I didnt find the table DimSalesOrderLine in above screenshot.

    Why you create so many dim tables?

    I'm not sure whether it's the problem,but I would suggest you change the relationship I marked in red from both to single.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!