0 Replies Latest reply: Jan 30, 2013 2:02 AM by 987999 RSS

    Fact table is joining with Other table having values for measures

    987999
      I have one Fact table named Fact1 where i am going to create some calculation measures based on the values in Table2.
      How should be the physical join between them and the logical join.

      Earlier we had those VALUES in Fact1 only
      Why we created table Table2 is there was bit confusion for the aggregation in Fact1.


      We are bit confused on whether to make Table2 as dimension or Fact as it is having some measures and not having the foreign keys

      How we have to proceed now..!! Please help us!!?