PLATFORMS: The warehouse relational database for query and reporting is based on Oracle and operates on a Sun Solaris server running UNIX. The multidimensional database for summary analysis is Arbor Essbase and operates on a Compaq server running Windows NT. Users are using Windows 95.

BACKGROUND: Canadian Imperial Bank of Commerce (CIBC) is a $238 billion publicly owned bank. The electronic banking division supports the remote delivery of financial services through automated banking machines, PC banking, the Internet and telephone banking.

PROBLEM SOLVED: The electronic banking division has a unique requirement for a daily, comprehensive, transactional, single source of customer activity data that could not be met by the bank's existing reporting systems. The system was required to provide reporting and analysis capabilities to support performance measurement and monitoring for all aspects of the electronic banking business.

STRENGTHS: Fiserv InformEnt provides a complete package to build, manage and use an enterprise-wide data warehouse. The Fiserv staff helped us to review, assess and build our data collection reporting and analysis skills. An established 6,500 element data model-- specific to the financial industry--was a key factor for CIBC. Fiserv then developed and implemented a 300-element expansion to the base data model to support additional transactional-activity data needed by electronic banking. The incremental EnterMart approach to providing early and ongoing deliverables was essential for this rapidly changing, quickly growing, in- production business unit.

WEAKNESSES: The key challenge for CIBC is to get the knowledge transferred from Fiserv to CIBC so that we can support the system on an ongoing basis. Tight project time lines did not allow for warehouse development and support skills to be transferred. The rapidly changing nature of electronic banking means that the data warehouse, its model and its operation will be in a continual state of evolution. This has introduced new requirements and considerations for all production level systems that feed data into the warehouse.

PRODUCT CHARACTERISTICS: InformEnt provided CIBC Electronic Banking with a proven, production-level information management system. The ability to automate and schedule both data loading and analysis has refocused staff efforts from data collection/report production to information analysis. The reporting interfaces are user friendly, allowing deployment to the business end users. InformEnt's multidimensional analysis capabilities provide business users across the organization with the ability to slice and dice the data for analysis purposes.

SELECTION CRITERIA: A fully integrated enterprise- wide information management solution encompassing a financial industry-specific data model, seamless integration of multidimensional and relational analysis, along with "end-to- end" user-oriented meta data was required. An ongoing partnership for customization of the warehouse and flexibility to expand functionality to address our diverse information management needs are all part of why we chose InformEnt.

DELIVERABLES: Information management requirements were defined and developed in the data warehouse--using a combination of InformEnt's data stewardship tools, including relational and multidimensional databases. The flexibility of InformEnt's architecture enabled us to expand the scope of the warehouse by 300 data elements from definition to production in less than three months. InformEnt delivered a production-level analysis infrastructure resulting in daily data feeds of mass volumes of information and automated scheduling of complex relational and multidimensional and analysis.

VENDOR SUPPORT: Support from the InformEnt Team has been excellent. The quality of people assigned to work on our project has been exceptional.

DOCUMENTATION: The written documentation was timely, concise and accurate.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access