BI Module – Order Management
The Order History fact table is a Summary or Accumulating table. This table shows a history of order lines over time. Each time a row changes, the “old” row is end dated with the previous days date and a new row is added with a start date of the current date.
The Current Flag should be used to filter this table.