Forum Discussion

BillColeman's avatar
BillColeman
Frequent Visitor
6 years ago

Incremental refresh on append query with some dates in the future

I've got a composit fact table made from 3 appended (unioned) tables 

  1. 10 years of sales history
  2. Budget and forecast data from the past and the coming financial year
  3. Some inventory snapshot data from the last available date

I need to configure an incremental refresh on this appended fact table that reloads the last 10 days of sales data, but allows future data for budget and forecasting and always refreshes the inventory snapshot. All use the same YYYYMMDD date key

 

Worst case, I could write a union query at the source so I'm only dealing with a single entity in m-query, but I'm still left trying to allow for future dates in budget and forecasting records. 

 

Is this possible? Has anyone done this before? I really don't want to have to re-define the data model to use individual fact tables. Any ideas?

 

Thanks all