Forum Discussion
Data Model Question - Sales Order Line and Shipment Details
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,
KellyDid I answer your question? Mark my reply as a solution!
RSSapre , First of all, what was needed from the line dimension, for which you made it dimension.
For 1-1 Join, I would prefer to merge tables
or Make 1-M single direction from Dim to Fact, If this one does not work share the data model with me, with answer to the first question
Also, make sure detail dimension do not join with any other dimension
Thanks for your suggestion. After a discussion with the team, we do not need line dimension in Power BI. I removed all the relationships from the shipment details. Kept Many to One relationship (active) between Order Lines and Shipment with direction = double. I had to keep some inactive relationships on dates in Shipment table for the measures. I think my model is working for now. I am testing the data to ensure it.
Hi RSSapre ,
Would you pls show us some screenshots of the relationship?
Remember to remove the confidential information.
Best Regards,
KellyDid I answer your question? Mark my raeply as a solution!