I have two dimension.

one is Manufacturer

[![enter image description here](https://i.stack.imgur.com/Ni6NK.png)](https://i.stack.imgur.com/Ni6NK.png)

Other is Supplier.

[![enter image description here](https://i.stack.imgur.com/xULB7.png)](https://i.stack.imgur.com/xULB7.png)

Have a fact table.

[![enter image description here](https://i.stack.imgur.com/BSSiu.png)](https://i.stack.imgur.com/BSSiu.png)

Need to query the sales amount using supplier code, also want to see the relation between Supplier and Manufacturer against sales amount.
Can this be done.

Is there any possibilities that can be achieved without adding a supplier key to fact.

Please help!!!