Forum Discussion
Sales Order Line fact to Invoice Line Fact model
Hi, I would like to know what is the best practice to create model that combines sales orders and inovices. Current state is that I have two fact tables „Sales Order Line“ and „Invice Line“ gran...
PetrarteP , Ideally two facts should not join, not it is good to have such a big common dimension.
What is requirement to join these two ? What expected output for which you need to join these two
Hi,
Basically users would like to slice the Invoice data over attributes/dimensions that are only on sales order (medical data like Surgeon, Patient, Procedure, contracts....). And in general check which sales orders ended with invoice and validate totals.