Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How can I link more than one dimension fields to a fact table at the time of loading data
Upali
Any identical [case sensitive] field names in different tables will result in a link.
So if your Fact Table is say:
Then Table DimA will join on:DimA-ID
And Table DimA will join on:DimB-ID
Best Regards, Bill
.
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.