Logical modeling in the new development project
- Open the new industry model development project. Look under
Banking Data Warehouse model.ldm * >
09.Analysis Area. You should see only the
objects you selected in the "Scope the
model with conceptual model and analytical requirements model
in EME/IDA" section.
Figure 15. Scoped analysis area under new Industry Model Development project
- To see a complete data mart model, navigate to Banking
Data Warehouse Model.idm * >
Analysis > Diagrams, then
right-click and select New Blank Diagram.
Figure 16. New blank logical model diagram
- Now you can select all the entities you need for a complete data mart model and move it to the blank diagram. Start with the Campaign Analysis entity that lies under Banking Data Warehouse Model > IFW Summary and Analysis > Analysis.
- Next, select the dimension entities. For example, you can select
the dimensional entity Organization Unit
Geography, located under Banking Data
Warehouse Model > IFW System of
Record > Classification, as shown
in Figure 17:
Figure 17. Creation of Campaign Analysis data mart diagram
You can do this for all dimensional entities by checking the foreign keys in the fact entity and looking for all the corresponding entities.
- After this, look at the Generalization and Classification
entities. For example, you see that the entity Measurement Period
Type classifies Measurement Period. The Measurement Period entity
holds attributes like dates and timestamps. These attributes are
used to build up the history for the attributes in the fact table
Campaign Analysis. The Measurement Period is modeled in BDW as a
special concept (in other words, an entity) of a more generic
concept. Therefore, you see that Time Period Type ("supertype") is
a generalization of Measurement Period Type ("subtype"). Also,
Event is a supertype for the subtypes Campaign and Communication.
These concepts are illustrated in the data model shown in Figure 18. This is a good starting point for
further modeling of the logical data model.
Figure 18. Logical data mart model for Campaign Analysis
- Next, you include the summary entity Campaign Summary to your data
mart model. This summary entity holds attributes, which can hold
aggregations and totals of measures from the fact entity Campaign
Analysis. So Campaign Summary holds a number of very important
measures that have business value for the campaign analysis task.
You can see all these entities in the diagram shown in Figure 19:
Figure 19. Logical data mart model for Campaign Analysis, including Campaign Summary
Besides Campaign Summary, there are two other summary entities that are created under this scope:
- Arrangement Activity Summary
- Employee Summary
When you have integrated these summary entities in the logical model diagram, you will get a logical data mart model with three summary entities. You will also get a connection entity called Summary Characteristic. This entity shows the relationships between the summary entities. The entity holds the common foreign keys from all three summary entities (Measurement Period Id and Scenario Id). So Summary Characteristic plays the role of an anchor entity. In addition, you can integrate technical information entities (which are provided by BDW), such as Population Event With Unique Id Characteristic. This entity now holds several attributes with technical information, like the time of the population process or the identifier of the source system. This population information is linked with the generic entities Involved Party and Arrangement. By doing all these steps, you finally get the diagram shown in Figure 20:
Figure 20. Summary area for Campaign Analysis, including Campaign Summary
For each entity and for each attribute in the logical model diagram, you can see the original documentation of the IBM Industry Model BDW 8.2. In Figure 21, for example, you see the definition of the entity Measurement Period:
Figure 21. Documentation of the entity Measurement Period
Figure 22 shows the definition (under Properties > Documentation) of the attribute Total New Funds From Campaign in the entity Campaign Summary:
Figure 22. Documentation of an attribute in Campaign Summary