Rural Credit Banks Funds Clearing Center is approved by the People’s Bank of China and joined by nationwide 30 province-level rural credit union associations, rural commercial banks, rural cooperative banks and Shenzhen Rural Commercial Bank to sponsor establishment of a national joint shares financial clearing services company, and also others kinds of joint shares financial service institutions approved by the People's Bank of China. Rural Credit Banks Funds Clearing Center is allowed to process bank drafts, real-time electronic exchange, and personal account clearing services among national rural credit centers, rural credit associations, rural cooperative banks, rural commercial banks and other local financial institutions.
Project Background
As Rural Credit Banks Funds Clearing Center business growing, the center and the shareholders are willing to explore and analyze current various business data through one central platform, to further deeper display report and provide information support to leaders for decision making. Rural Credit Banks Funds Clearing Center Report System introduced ETL tool to integrate old existing systems and new systems data by extracting data to one central data warehouse. Rural Credit Banks Funds Clearing Center Report System process overall planning for Data warehouses to establish practical data models, not only meet the current business reports requirements, and also make a solid foundation for further data analysis.
Rural Credit Banks Funds Clearing Center Report System's goal is to entire display and management to establish an advanced, safe, open and expandable report display and analysis platform.
Mainly divided into the following modules:
-System Capacity Statistics Tables: Statistics for all systems handling capacity;
-Transaction Volume Statistics Tables: Statistics including exchange, bills of exchange, cross banks deposit and cross banks withdraw and information such as the transaction volume;
-Sales Volume Statistics Tables: Statistics including exchange, bills of exchange, cross banks deposit and cross banks withdraw and the business information like situation. In addition, further statistics cross banks deposit and cross banks withdraw business success rate;
-Liquidation Statistics Tables: Statistics of all business liquidation;
-Money Supply Statistics Tables: Statistics of liquidation account, money supply and average daily balance;
Business Analysis Table: Statistics granule analysis by month and day of Rural Credit Banks Funds Clearing Center and the shareholders' business trend circumstances.
Environment Deployment and Implementation
-Operating system environment AIX5.2
-Database and data warehouse: DB2 8.2
-Report tools: MicroStrategy8.1.1
-ETL tools: Pervasive8.14
-Architecture: pure B / S structure
-Users: Rural Credit Banks Funds Clearing Center leaders, fund settlement and IT Department staffs
-Structure: LAN
Applications Results
Rural Credit Banks Funds Clearing Center Report System introduces ETH solutions of reports in this project, and fully demonstrates MicroStrategy8 version and Pervasive product functions, particularly some characteristics features, such as the unique MicroStrategy district mapping function. Overall, the following points provide this project development great convenience:
Complex business logic relationship definitions: As MicroStrategy products using fully object-oriented development methods, analysis processes in all kinds of business logic are defined as objects, so this method brings a good package to compose relatively simple objects to into complex combination objects to achieve the purpose of complex business logic integrating closely with background database system.
Perfect combination with Excel: This function very popular by clients. Clients are intending to save report result into local hard disk in excel format. MicroStrategy solves this requirement, it save MicroStrategy report into Excel files, and also keeps formats complete.
Powerful web functions: This function is also unique in MicroStrategy. It can directly create reports, edit report, define report formats in flexible ways through web browsers, and not required to download any activeX controls to maintain a strong Web functions, and also ensure web security and network traffic not to increase dramatically.
Mapping functions: This project applied MicroStrategy unique district mapping technology. To allocate monthly data in different facts table, but these facts table structures are all the same. Through MicroStrategy unique district mapping technology, it increases query efficiency by physically data in many tables, but logically data in one table.
