3 Replies Latest reply: Jul 9, 2014 8:11 AM by Alec Smith RSS

    Master Calendar with Two Fact Tables

    Alec Smith

      Hello,

       

      Is it possible to create a Master Calendar that can work between two fact tables?  See attached data model.  I have Sales Order and Invoice tables that both contain transaction dates.  I would like to create one Master Calendar that has a Year and Month dimension so I can have a List Box for Year and Month respectively. 

       

      Thank you in advance for any information on this.