Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Star schema modelin OrderHeader and OrderDetails

Hi,   I have and OrderHeader table with the unique Order_id and the OrderDetails with many products, which relates to one Order.   So: OrderHeader 1:n OrderDetails    Should i put OrderHeader a...
  • KNP's avatar
    5 years ago

    Anonymous- that is very dependent on what you're trying to achieve with your reporting from this model and probably not really enough info to provide a definitive answer. 

    For example, if there's a need to report on individual orders, your order headers table may act as a dimension and if that level of granularity is not required, then amitchandak may be correct and merging the tables may be the correct approach.

     

    It would probably be worthwhile sharing a screen shot of the model as it stands currrently showing the existing relationships.

     

    Best practice for Power BI performance is always a star schema but defining whether something is a fact or dimension often depends on the grain required for reporting.

     

    Hope this helps.