My first Publication Agile-Data-Warehouse-Design-eBook | Page 125
104
Chapter 4
Event Sequences
Events are listed on
the matrix in value
chain sequence
Look back at the event rows on the matrix in Figure 4-6 and you will notice that
events are not listed alphabetically. Instead, they are listed in value sequence begin-
ning with MANUFACTURING PLANS, and ending with WAREHOUSE
SHIPMENTS. This sequence orders the events by the increasing value of their
outputs. In this example, the sequence starts with potentially valuable planning
followed by the procurement of lower value components, and proceeds through
the building and shipment of higher value products. When business activity is
ordered in this way it is often referred to as a value chain.
Time/Value Sequence
Value sequence can
also represent time
sequence which
helps stakeholders
to think of the next
and previous events
Value sequence can also represent time sequence. Generally low value output
activity occurs before high value output activity or at least that is how most of us
think of business activity at a macro-level. For example, in manufacturing, pro-
curement happens before product assembly, shipping, and sales. Similarly, in
service industries, time and money is spent acquiring low value (high cost) pros-
pects before converting them into potentially valuable customers and then into
high value (low cost) repeat customers. In reality, value sequencing may not be a
strict chronology because many of the micro-level business events described in a
value chain occur simultaneously and asynchronously—not waiting for one an-
other. However, time/value sequencing is highly intuitive and by documenting
events in this way, the matrix helps stakeholders to think of next or previous events,
and spot gaps (missing links) in their value chains.
Add events to an event matrix in the order in which they increase business value
by asking “Who does what next that adds value?”
Process Sequence
Events that occur in
a strict sequence
often represent
process milestones
Milestone events
are indented
beneath the event
that triggers them.
A
* degenerate
dimension creator
often indicates the
start of a process
sequence
Within the flexible chronology of value chains there will be stricter chronological
sequences of events that must occur sequentially to complete a significant time
consuming process such as order fulfillment or insurance claim settlement. These
process sequences—which begin with a process (initiating) event and continue
serially through a number of milestone events—are denoted on an event matrix by
indentation.
Figure 4-6 shows a process sequence of PURCHASE ORDERS to SUPPLIER
PAYMENTS. This documents that a delivery only occurs after a purchase order
(PO) has been processed and a payment is only made after a delivery has been
received. Notice that these events share a conformed PO dimension. This may only
be a degenerate PO NUMBER dimension in each event table but it ties these events
together at the atomic detail level and allows stakeholders to track the progress of
each PO item through delivery and payment. Notice also that POs are created by
PURCHASE ORDER events (denoted by a * on the matrix): PO numbers are
generated when an employee raises a purchase order. This confirms the strict