title: How to solve if there are two different granularity in data mart ?
body: <p>We are creating data mart from data source that we are given. I have created following tables in data mart.</p>
  
  <pre><code>FactPopulation (Fact table which has population data per year)
  FactMeeting count (Fact table which has event info occur almost everyday 2005-)
  DimMeeting Topic (Name of Meetings)
  DimGeography (Place)
  DimDate (Date Dimension)
  </code></pre>
  
  <p>So if I want to do analysis Population and meeting county have different granularity. I want to do analysis by year and by month. Is it any way to combine both fact table into one or any suggestion ?</p>