5 Replies Latest reply: Jul 2, 2015 9:44 AM by Sinan Ozdemir RSS

    Help with generic keys with 2 facts

      hi guys,

      I have following tables:

       

      Fact1:

      Load

      DocNoID,

      Amount,

      SalespersonID,

      Date

      Resident All;

       

      Fact2:

      Load

      DocNoID,

      CustomerID,

      EndcustomerID

      Resident Sales;

       

      Customer:

      Load CustomerID, Customername, CustomerCountry

      Resident Customer.qvd (qvd);

       

      Endcustomer:

      Load EndcustomerID, Endcustomername, EndcustomerCountry

      Resident Endcustomer.qvd (qvd);

       

       

      TargetsByYear:

      SalespersonID,

      Date,

      TargetAmount

      FROM  XY;

       

      which way is right to make generic keys?