Tabular Model Facts Relationship

• udia

  SSC Rookie

  Points: 37

  More actions

  December 27, 2016 at 1:03 pm

  #146325

  Hi,

  I am trying to build a tabular model that has two main Fact tables - Fact_Volume and Fact_Campaigns

  Fact_Volume - contains a record for each volume transaction received by a customer.

  Fact_Campaigns - contains a record for each mail that was sent to a customer under a specific campaign (a customer can get many mails under different campaigns and many mails under the same campaign on different times).

  The two fact tables shares the Dim_Customer table.

  I want to create measures that will calculate for each sent campaign mail (specific campaign for a specific customer) the sum of volume amount that the customer received X days since the mail was sent.

  For example: Volume Loaded 7 Days Since Campaign A, Volume Loaded 14 Days Since Campaign A, Volume Loaded 30 Days Since Campaign A etc.

  I am not sure how to connect my fact tables in order to achieve these measures.

  Any Ideas???

  Thanks!