BI Data Model

Previous Next JavaScript must be enabled to correctly display this content

3.5 BI Data Model

The BI data model is a star schema for the fact table FCT_<APPLICATION>_ACCOUNT_SUMMARY.

Following are the subject areas in the erwin data model:

Figure 3-3 Fact Account Feature Map

This illustration depicts the Fact Account Feature map.

Figure 3-4 Fact Account Manager Relationship

This illustration depicts the Fact Account Manager Relationship.

Figure 3-5 Fact Account Party Role

This illustration depicts the Fact Account Party Role.

Figure 3-6 Fact Account Profitability

This illustration depicts the Fact Account Profitability.

Figure 3-7 Fact Account Segment MOB Summary

Thie illustration depicts the Fact Account Segment MOB Summary.

Figure 3-8 Fact Account Segment Score

This illustration depicts the Fact Account Segment Score.

Figure 3-9 Fact Applications Summary

This illustration depicts the Fact Applications Summary.

Figure 3-10 Fact Common Account Summary

This illustration depicts the Fact Common Account Summary.

Figure 3-11 Fact Common Customer Summary

This illustration depicts the Fact Common Customer Summary.

Figure 3-12 Fact CRM Account Summary

This illustration depicts the Fact CRM Account Summary.

Figure 3-13 Fact Customer to Customer Relationship

This illustration depicts the Fact Customer-toCustomer Relationship.

Figure 3-14 Fact Economic Capital Account Summary

This illustration depicts te Fact Economic Capital Account Summary.

Figure 3-15 Fact Opportunity

This illustration depicts the Fact Opportunity.

Figure 3-16 Fact Opportunity Activity

This illustration depicts the Fact Opportunity Activity.

Figure 3-17 Fact Regulatory Capital Account Summary

This illustration depitcs the Fact Regulatory Capital Account Summary.

Figure 3-18 Fact Sales Representative Compensation

This illustration depitcs the Fact Sales Representative Compensation.

Figure 3-19 Fact Transaction Summary

This illustration depicts the Fact Transaction Summary.

Figure 3-20 Funds Transfer Pricing (FTP) Account Summary

This illustration depicts the Funds Transfer Pricing (FTP) Account Summary.

Figure 3-21 Profitability Management (PFT) Account Summary

This illustration depicts the Profitability Management (PFT) Account Summary.

Figure 3-22 PFT Customer Summary

This illustration depicts the Profitability Management (PFT) Customer Summary.