11 Replies Latest reply: Mar 6, 2012 9:47 AM by Anosh Nathaniel RSS

    multiple fact tables

    Chandan Chakraborty

      Hi Friends,

       

      I have the following table structure:

       

       

      Fact tables:

       

       

      LatexCollection

      ---------------

      Date                               FieldNo                Empno                 LAT

      01/04/2010            1                   W001                    10

       

       

      TreesPlanation

      --------------

      Date                              FieldNo                         Tree_Planted               Tree_Lost

      30/04/2010               1                              1000                                        30

      30/05/2010               2                              6000                                        100

       

       

      Dimension tables:

       

       

      FieldMaster

      -----------

      FieldNo                         Name

      1                                   F2010

      2                                   F2009

       

       

      Calendar

      --------

      Date                                   Year                    Month

      01/04/2010               2010               apr

       

       

       

      Can anybody suggest how to make relationship among these tables.

       

       

       

       

      regards and thanks

      chandan