{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2022,6,1]],"date-time":"2022-06-01T20:40:23Z","timestamp":1654116023127},"reference-count":14,"publisher":"IGI Global","issue":"3","content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":[],"published-print":{"date-parts":[[2013,7,1]]},"abstract":"<p>In this paper the authors describe a method to integrate explanatory business analytics in OLAP information systems. This method supports the discovery of exceptional values in OLAP data and the explanation of such values by giving their underlying causes. OLAP applications offer a support tool for business analysts and accountants in analyzing financial data because of the availability of different views and managerial reporting facilities. The purpose of the methods and algorithms presented here, is to extend OLAP applications with more powerful analysis and reporting functions. The authors describe how exceptional values at any level in the data, can be automatically detected by statistical models. Secondly, a generic model for diagnosis of atypical values is realized in the OLAP context. By applying it, a full explanation tree of causes at successive levels can be generated. If the tree is too large, the analyst can use appropriate filtering measures to prune the tree to a manageable size. This methodology has a wide range of applications such as interfirm comparison, analysis of sales data and the analysis of any other data that possess a multi-dimensional hierarchical structure. The method is demonstrated in a case study on financial data.<\/p>","DOI":"10.4018\/ijbir.2013070105","type":"journal-article","created":{"date-parts":[[2013,9,3]],"date-time":"2013-09-03T15:52:48Z","timestamp":1378223568000},"page":"67-82","source":"Crossref","is-referenced-by-count":1,"title":["Explanatory Business Analytics in OLAP"],"prefix":"10.4018","volume":"4","author":[{"given":"Emiel","family":"Caron","sequence":"first","affiliation":[{"name":"Centre for Science and Technology Studies, Leiden University, Leiden, The Netherlands"}]},{"given":"Hennie","family":"Daniels","sequence":"additional","affiliation":[{"name":"Center for Economic Research, Tilburg University, Tilburg, The Netherlands, & Rotterdam School of Management, Erasmus University, Rotterdam, The Netherlands"}]}],"member":"2432","reference":[{"key":"ijbir.2013070105-0","unstructured":"Caron, E. A. M. (2012). Explanation of exceptional values in multi-dimensional databases. Unpublished Ph.D. thesis, Erasmus University Rotterdam."},{"key":"ijbir.2013070105-1","unstructured":"Caron, E. A. M., & Veenstra, A. (2007). Explanation of exceptional values in multidimensional business databases - with a case study on the analysis of vehicle criminality data. In Proceedings of International Conference on Industrial Engineering and Systems Management, Beijing, China. Tsinghua University Press."},{"key":"ijbir.2013070105-2","year":"2008","journal-title":"Cognos 8 business intelligence"},{"issue":"1-2","key":"ijbir.2013070105-3","first-page":"5","article-title":"Automated explanation of financial data. Intelligent Systems in Accounting","volume":"16","author":"H. A. M.Daniels","year":"2009","journal-title":"Financial Management"},{"key":"ijbir.2013070105-4","doi-asserted-by":"publisher","DOI":"10.1016\/S0377-2217(99)00428-2"},{"key":"ijbir.2013070105-5","author":"J.Han","year":"2005","journal-title":"Data mining: Concepts and techniques"},{"key":"ijbir.2013070105-6","author":"W. H.Inmon","year":"1996","journal-title":"Building the data warehouse"},{"key":"ijbir.2013070105-7","doi-asserted-by":"publisher","DOI":"10.1016\/0378-7206(81)90032-X"},{"key":"ijbir.2013070105-8","author":"R.Kimball","year":"1996","journal-title":"The data warehouse toolkit: practical techniques for building dimensional data warehouses"},{"key":"ijbir.2013070105-9","doi-asserted-by":"publisher","DOI":"10.2307\/2392045"},{"issue":"1","key":"ijbir.2013070105-10","first-page":"1","article-title":"The process of problem finding.","volume":"11","author":"W. F.Pounds","year":"1969","journal-title":"Industrial Management Review"},{"key":"ijbir.2013070105-11","doi-asserted-by":"publisher","DOI":"10.2307\/1906872"},{"key":"ijbir.2013070105-12","doi-asserted-by":"publisher","DOI":"10.1037\/13978-000"},{"key":"ijbir.2013070105-13","doi-asserted-by":"publisher","DOI":"10.1177\/016555159301900204"}],"container-title":["International Journal of Business Intelligence Research"],"original-title":[],"language":"ng","link":[{"URL":"https:\/\/www.igi-global.com\/viewtitle.aspx?TitleId=83479","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2022,6,1]],"date-time":"2022-06-01T20:03:13Z","timestamp":1654113793000},"score":1,"resource":{"primary":{"URL":"https:\/\/services.igi-global.com\/resolvedoi\/resolve.aspx?doi=10.4018\/ijbir.2013070105"}},"subtitle":[""],"short-title":[],"issued":{"date-parts":[[2013,7,1]]},"references-count":14,"journal-issue":{"issue":"3","published-print":{"date-parts":[[2013,7]]}},"URL":"https:\/\/doi.org\/10.4018\/ijbir.2013070105","relation":{},"ISSN":["1947-3591","1947-3605"],"issn-type":[{"value":"1947-3591","type":"print"},{"value":"1947-3605","type":"electronic"}],"subject":[],"published":{"date-parts":[[2013,7,1]]}}}