Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Customer and supplier at same time

Go down

Customer and supplier at same time Empty Customer and supplier at same time

Post  fabriciabarbosa Mon Aug 10, 2015 8:28 am

Hi, Everyone

I would like you help for my project. I have a dilemma.

My data model is related to Business Industry. We have several factories and several deposits related to it. The deposits vedem products to customers, but perform transfer of products between them. In this case, the seller is also a client.

I thought of desing 2 tables fact .: 1 - Sales 2 - transfer.

like this,

1)

customer_id
product_id
qt_product


2)
deposit_id (not customer_id)
product_id
qt_product

the problem is: the manager wants to see the total cost of manufacturing output. And so, we have 2 cost facts.

Is there a way to have a single fact cost?


best regards,
Fabricia Barbosa

fabriciabarbosa

Posts : 3
Join date : 2014-03-12
Age : 46
Location : Recife, Brazil

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum