What about multiple fact scenarios like sales orders and invoices. Parts of a sales order can be dispatched and invoices separately. Even sales order lines can be split with second dispatch for back-ordered quantity. There is a need to link sales order lines to invoice lines.
@lesliewelch2890
2 күн бұрын
What is the relationship between the two? Is it always one or more invoices per sales order, or are there also sometimes multiple sales orders associated with one invoice?
@mrbartuss1
2 күн бұрын
What about shared dimensions?
@coolblue5929
3 сағат бұрын
@@lesliewelch2890 in my case it’s always one sales order per invoice and sometimes multiple invoices for a sales order.
@coolblue5929
3 сағат бұрын
@@mrbartuss1 the shared dimensions filter via the sales orders.
Пікірлер: 5