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 ERwin data model:

·        Fact Account Feature Map

·        Fact Account Manager Relationship

·        Fact Account Party Role

·        Fact Account Profitability

·        Fact Account Segment MOB Summary

·        Fact Account Segment Score

·        Fact Applications Summary

·        Fact Common Account Summary

·        Fact Common Customer Summary

·        Fact CRM Account Summary

·        Fact Cust Cust Relationship

·        Fact Eco Cap Account Summary

·        Fact Opportunity

·        Fact Opportunity Activity

·        Fact Reg Cap Account Summary

·        Fact Sales Representative Compensation

·        Fact Transaction Summary

·        FTP Account Summary

·        PFT Account Summary

·        PFT Customer Summary