title: Dimensional modeling for sales fact with product and inventory dimension
body: <p>I am building a dimensional model for sales analysis that has a fact called Sales and is linked with a Product dimension.</p>
  
  <p>Point is that for each day the Product inventory will change, and this information is important for them to analyse why a specific product wasn't sold (for example, on day XX/XX the product 123456 wasn't sold because there where no products in the inventory).</p>
  
  <p>I'd like to know the best option to modeling this situation and if possible a short explanation about how it'd work. </p>
  
  <p>Thanks in advance!</p>