Design Of Financial Statement System Based On MOLAP

The Kangan Insurance is based on customized templates and the company submits reports to the regulatory and management level. Along with the refinement in management, the finance department needs to submit one-time reports without using the standard format. In this case, two solutions can be chosen:sapling data fragments that are cut from several customized tables or developing temporary new tables by the IT staffs. Both methods consume considerable resources without the assurance of quality. Thus, a novel approach is proposed in order to satisfy the various requirements and to reduce the workload of IT staffs.At first, the problems that Kangan insurance financial report system faced due to the refined management are discussed. The advantages of MOLAP are analyzed and then the necessities of using MOLAP technology to design report system for the department are explained. Based on the discussion above, the important functions of the financial report system are discussed, including customizing on-line, saving, representation, and inquiry. Then the key processes such as data acquisition, data management, data representation and reports generation demonstrate are analyzed. Moreover, the system architecture is analyzed including the components such as data acquisition, data mart, MOLAP appellation server, portal management and end-users. And the key subsystems including Metadata management, data cube model, reports representation and so on are designed in detail. Most importantly, MOLAP and the appellations of multi-dimensional analysis operations like Sling, rotating, and drilling in customizing reports on-line are expatiated.