OLAP Relationships

The second step in the workshop is to examine the individual relationships by creating a Entity-Relationship Model (E-R Diagram). Each relationship found in the context model is extracted, individually modeled on the whiteboard or CASE Tool and investigated by the members of the workshop. This step is done for each relationship, plus any relationships that were missed in creating the original context model (don't forget to update the Context Model). The word "Product" has been added to the business unit object to further clarify what elements exist in this relationship.

Each of the business objects identified in the relationship diagram contains a candidate data mart. Other data marts may be created by combining several business objects.

The names of the business objects are placed into a Business Objects List. A blank copy of each business object, plus an actual copy of an executed business object should be collected and placed into an exhibits folder.

These sample business objects will be examined, off-line from the workshop, to determine what organizations, people and things are represented in each object and how they are organized or related. These organizations, people, things and relationships identify the candidate data marts.