
2.2
Methods for Tuning a Data Warehouse 37
Chapter 2
SALE
. The SALES fact entity will contain attributes from the
ORDERS, ORDERSLINE, TRANSACTIONS, TRANSACTION-
SLINE, CASHBOOK, and CASHBOOKLINES entities, where the
TYPE values are set to the value “S”, implying a sale. Additionally,
the STOCKMOVEMENTS will be rolled into the SALE fact entity.
PURCHASE
. The PURCHASES fact entity will contain attributes
from the ORDERS, ORDERSLINE, TRANSACTIONS, TRANS-
ACTIONSLINE, CASHBOOK, and CASHBOOKLINES entities,
where the TYPE values are set to the value “P”, implying a purchase.
Additionally, the STOCKMOVEMENTS will be rolled into the
PURCHASES fact entity ...