Investigate INVOICE AGE fact on F_INVOICE_MANAGEMENT

ivylabs / suitecrm-data-integration

6 stars 5 forks source link

Investigate INVOICE AGE fact on F_INVOICE_MANAGEMENT #31

Closed harrisward closed 4 years ago

harrisward commented 4 years ago

INVOICE AGE is only calculated at ETL fact load time. This logic is likely flawed due to the INVOICE AGE never getting updated beyond the first time the fact is loaded into the DWH.

It might be an idea to create some additional ETL that updates INVOICE AGE values on a daily basis

harrisward commented 4 years ago

Removed INVOICE_AGE_DAYS and INVOICE_OVERDUE_DAYS from the F_INVOICE_MANAGEMENT fact table and ETL. Also removed from the DDL

fraserward commented 4 years ago

Checked!