title: Same Fact Table Column; Records with Multiple Reasons
body: <p>I am in a situation similar to the one below:</p>
  
  <p>Think for instance we need to store customer sales in a fact table (under a data warehouse built with dimensional modelling). I have sales, discounts related to the sale, sales returns and cancellations to be stored. </p>
  
  <p>Do you think it would be advisable to store sales for a day to a customer in a particular product (when the day is the grain) as a positive value while the returns and discounts are stored as minuses? </p>
  
  <p>Also if a discount is enforced to a customer at a level other than the product (for instance brand), do you think it is alright to persist it with a key particularly assigned to the brand (product is the grain) while the product column being given an N/A, for the particular record?</p>
  
  <p>Thanks in advance. </p>