3 Replies Latest reply: Oct 23, 2014 6:00 AM by Alessandro Saccone RSS

    1 Master calendar for two dates from seperate fact tables

    Robert Waterval

      Hi Guys,

       

      I'm facing the following problem.

      I have two fact tables with two important dates which I need to combine into one master calendar. As link these fact tables I have a compound key with dimensions A+B and stored the shared dimensions into a Link Table.

      Now is the question whats the best way how to develop one master calendar that can be used to analyse records from fact table A and fact table B. 

       

      Best regards,

      Robert