2 Replies Latest reply: Nov 3, 2013 10:45 AM by Jean-Pierre Bakhache RSS

    Data loadin

    UPALI WIJERATNE

      How can I link more than one  dimension fields to a fact table at the time of loading data

        • Re: Data loadin
          Bill Markham

          Upali

           

          Any identical [case sensitive] field names in different tables will result in a link.

           

          So if your Fact Table is say:

          • DimA-ID
          • DimB-ID
          • Fact-Value

           

          Then Table DimA will join on:DimA-ID

          • DimA-ID
          • DimA-Text

           

          And Table DimA will join on:DimB-ID

          • DimB-ID
          • DimB-Text

           

           

          Best Regards,     Bill

          .

          • Re: Data loadin
            Jean-Pierre Bakhache

            Hi,

             

            Keep also in mind that in QV you can link 2 tables with 1 field only.

            However, this key field can be a combination of several fields. For example:

             

            Scenario1: invoice detail linked through InvoiceNo to invoice header

             

            InvoiceHeader:

            Load InvoiceNo,

            Customer,

            etc...

             

            InvoiceDetails:

            Load InvoiceNo,

            LineNo,

            Item,

            etc...

             

            Scenario2: company, transaction type and transaction number constitute the key

             

            TransactionHeader:

            Load Company,

            TrxType,

            TrxNo,

            Company & ' | ' & TrxType & ' | ' & TrxNo as TrxKey,

            Customer,

            etc...

             

            TransactionDetails:

            Load Company & ' | ' & TrxType & ' | ' & TrxNo as TrxKey,

            ItemNo,

            Qty,

            Amount,

            etc...

             

            After validating your links, you can consider using the autonumber function to store the key field as a number instead of string (for performance):

            AutoNumber(Company & ' | ' & TrxType & ' | ' & TrxNo, 'TrxCounter') as TrxKey.

             

            Hope this helps you.