Good morning, i have two tables: Orders and Invoice.
One order belongs to one invoice but both tables could have different supplier. So when i select one order i would love to get all the information like addresse, country etc. from supplier_order AND supplier_invoice.
Right now my data model looks like this:
But as i want to add some more attributes and i need to use hierarchy load for the supplier dimension, because one supplier can have a parent supplier (not shown in the diagram) i wonder if it is possible just to have one supplier dimension but i can´t figure out how to do that. Most of the time I am getting a circular reference and i don´t know how to build some kind of bridge table and don´t know if it is the best way to solve the problem.
Maybe the data model should look something like this?!?