title: SQL Server BI: SIngle cube, multiple fact tables
body: <p>I'm new to creating cubes, so please be patient.</p>
  
  <p>Here's an example of my data
  I have multiple companies, each company has multiple stores.
  Sales are each linked to a particular company, with a particular store on a particular date.
  ex:5 sales took place for Company A, Store 1, on 5/19/2011
  Returns are linked to a particular company on a particular date.
  ex: 3 returns took place for Company A on 3/11/2012
  Sometimes my users want to see a list of stores, the date, and how many returns took place, and how many sales.
  Sometimes they want to see a list of companies, the specific stores, and the number of sales.</p>
  
  <p>I have a table that stores 
  COMPANY - DATE - STORE- SALES - RETURNS
  I end up having the value for returns repeated for each store under a particular COMPANY - DATE pair.
  so if I'm writing a query, and I want to find out returns, I just do a 
  select distinct company, date, returns from mytable</p>
  
  <p>but I am not sure how to this into a cube (using SS BI and Visual Studio).
  (I've only made a couple of cubes so far)</p>
  
  <p>Thanks! (also, feel free to point me at appropriate references)</p>