Hi, there are usually two solutions for this:
- Concatenate sales and transaction tables, so you end with only one fact table, wichmakes easier other reltaions with dimesnion tables avoiding circular references.
- Add keys from sales to tansaction table, so transaction has all the needed keys to allow sale to reach the calendar, something like:
// Load all keys loaded in transactions
chkKey:
LOAD distinct Key as chkKey resident Transactions;
// Add keys from Sales not already loaded in transactions
Concatenate (Transactions)
LOAD Key, sales_date, Cost center
Resident Sales
Where not exists('chkKey', Key);
DROP Table chkKey;
There can be other solutions like a relationship table but I usually use one of the two above.
.png "Former Employee"){kind=icon}
