My first Publication Agile-Data-Warehouse-Design-eBook | Page 129
108
Chapter 4
Remember, this question is designed to focus the stakeholders on identifying the
responsible subject (who) and object (what) of the event, to model its atomic-level
detail. If stakeholders respond with:
Warehouse worker ships product.
Add the next event
and any new
dimensions. Tick off
its conformed
dimensions
You add this new main clause to the matrix below CUSTOMER ORDERS, as in
Figure 4-9, leaving enough room to add an event name later. You then check the
dimension columns to see if the new subject (WAREHOUSE WORKER) and
object (PRODUCT) are potential conformed dimensions. PRODUCT is already on
the matrix so you should tick its use on the new event row, once you have con-
firmed that stakeholders are talking about the same products described in the same
way as before. Though it seems unlikely, you should also confirm that shipping
does not create new products otherwise you would use a * instead of a tick.
Figure 4-9
Adding “warehouse
worker ships
product” to the
event matrix
Role-Playing Dimensions
Check each new
dimension for
synonyms among
the dimensions
already on the
matrix
WAREHOUSE WORKER looks like a new dimension but before you add it you
should check if it is a synonym for an existing dimension; W-type can help you
here. WAREHOUSE WORKER is a who, and there are already two other whos:
CUSTOMER and SALESPERSON. Are either of these similar to warehouse work-
ers? Customers obviously aren’t but warehouse workers and salespeople, while
they’re not the same people, they maybe a specific type of who: employees of the
same organization. If so, they would share many common attributes (e.g., Em-
ployee ID, Department, Hire Date, etc.) and could be modeled as a single role-
playing conformed dimension. You should confirm with stakeholders:
Are warehouse workers and salespeople employees?