A Financial Assets and Liabilities Management Support System

Abstract

This paper describes the design and implementation of a decision support system (DSS) based on the fund dispatching decision viewpoint from the financial division of a business group. An integrated data warehouse is established and the technique of online analytical processing (OLAP) is applied to analyze daily transaction data of an enterprise resource planning system with determined management goal. We adopt the Business Dimensional Lifecycle approach to accomplish the system design and development. The DSS system developed is to provide latest and timely information of financial asset and liability positions in each company within the case business group so that decision makers can have a clear decision support in fund dispatching. While most related researches on fund dispatching focused especially on efficient banking capital management and few studies were done for general financial department of traditional enterprise let alone for the business group, this study has made a progress in this issue and the resultant system is applicable to the similar business group. Keywords: Financial Asset and Liability, Fund Dispatching, Decision Support Systems, OLAP, Data Warehouse