OLAP FOR FINANCIAL ANALYSIS AND PLANNING - A Proof of Concept

Eitel J. M. Lauría, Carlos A. Greco

Abstract

We describe the design of an in-memory OLAP model for financial planning, analysis and reporting at a medium sized manufacturing company in South America. The architecture and data model design are explained within the context of the company’s requirements and constraints.

References

  1. Codd E. F., Codd S. B., and Salley C. T., Providing OnLine Analytical Processing to User-Analysts: An IT Mandate. 1993, E.F. Codd and Associates.
  2. Golfarelli, M., S. Rizzi, and A. Proli, Designing what-if analysis: towards a methodology. In Proceedings of the 9th ACM international workshop on Data warehousing and OLAP. 2006, ACM: Arlington, Virginia, USA.
  3. Hasan, H. and P. Hyland, Using OLAP and Multidimensional Data for Decision Making. IT Professional, 2001. 3(5): p. 44-50.
  4. Higgins, R. C., Analysis for financial management. 6th ed. The Irwin/McGraw-Hill series in finance, insurance, and real estate. 2001, Boston: Irwin/McGraw-Hill.
  5. Kimball, R. and M. Ross, The data warehouse toolkit: the complete guide to dimensional modeling. 2nd ed. 2002, New York: Wiley. xxiv, 436 p.
  6. Koutsoukis, N.-S., G. Mitra, and C. Lucas, Adapting online analytical processing for decision modelling: the interaction of information and decision technologies. Decision Support Systems, 1999. 26(1): p. 1-30.
  7. Thomsen, E., OLAP Solutions: building multidimensional information systems. 2nd ed. 2002, New York: Wiley Computer Pub. xxiv, 661 p.r.
Download


Paper Citation


in Harvard Style

Lauría E. and Greco C. (2010). OLAP FOR FINANCIAL ANALYSIS AND PLANNING - A Proof of Concept . In Proceedings of the 5th International Conference on Software and Data Technologies - Volume 1: DMIA, (ICSOFT 2010) ISBN 978-989-8425-22-5, pages 347-355. DOI: 10.5220/0003042603470355


in Bibtex Style

@conference{dmia10,
author={Eitel J. M. Lauría and Carlos A. Greco},
title={OLAP FOR FINANCIAL ANALYSIS AND PLANNING - A Proof of Concept},
booktitle={Proceedings of the 5th International Conference on Software and Data Technologies - Volume 1: DMIA, (ICSOFT 2010)},
year={2010},
pages={347-355},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0003042603470355},
isbn={978-989-8425-22-5},
}


in EndNote Style

TY - CONF
JO - Proceedings of the 5th International Conference on Software and Data Technologies - Volume 1: DMIA, (ICSOFT 2010)
TI - OLAP FOR FINANCIAL ANALYSIS AND PLANNING - A Proof of Concept
SN - 978-989-8425-22-5
AU - Lauría E.
AU - Greco C.
PY - 2010
SP - 347
EP - 355
DO - 10.5220/0003042603470355