BIR 2010: Perspectives in Business Informatics Research pp 212-219 | Cite as
End User Development for OLAP – A Scenario from Food Industry
Abstract
Database applications allow the analysis of complex and large data sets. Such applications typically offer a lot of analysis functions to reveal all kinds of relations inside the data. Nevertheless end-users quite often face situations where they require viewing certain data or relations that is not easily provided by their existing analysis software. To overcome these situations they need means to create their own user interfaces to data that fit their specific requirements. Our solution is a tool that is easily usable for end users, doesn’t require any programming knowledge, but enables them to quickly build a customized user interface to view the data they are specifically interested in. This paper illustrates the usage of our tool in a typical scenario taken from one of our industrial project partners. We show how our tool allows end users to specify interactive applications like spreadsheets. The developed tool is build on top of an OLAP application and is partially based on the Qt Designer.
Keywords
End user development OLAP Business Intelligence Qt DesignerPreview
Unable to display preview. Download preview PDF.
References
- 1.Ballinger, D., Bidle, R., Noble, K.: Spreadsheet Visualisation to Improve End-user Understanding. In: Australian Symposium on Information Visualisation, Adelaide, Australia (2003)Google Scholar
- 2.Burnett, M., Cook, C., Pendes, O., Rothermel, G., Summet, J., Wallace, C.: End-User Software Engineering with Assertions in the Spreadsheet Paradigm. In: Proc. International Conference on Software Engineering, Portland, Oregon, USA, pp. 93–103 (2003)Google Scholar
- 3.Chitnis, S., Yennamani, M., Gupta, G.: ExSched: Solving Constraint Satisfaction Problems with the Spreadsheet Paradigm. In: CoRR. abs/cs/0701109, p. 1 (2007)Google Scholar
- 4.Dmitriev, S.: Language oriented programming: The next programming paradigm. In: JetBrains ’onBoard’ electronic monthly magazine (2004), http://www.onboard.jetbrains.com/is1/articles/04/10/lop/
- 5.Erwig, M., Abraham, R., Cooperstein, I., Kollmansberger, S.: Automatic Generation and Maintenance of Correct Spreadsheets. In: Proc. ICSE’05, St. Louis, Missouri, USA, May 15–21, pp. 136–145 (2005)Google Scholar
- 6.Marc II, F., Jin, D., Rothermel, G., Burnett, M.: Test Reuse in the Spreadsheet Paradigm. In: IEEE International Symposium on Software Reliability Engineering, p. 1 (2002).Google Scholar
- 7.Hodgins, J., Bruckman, A., Hemp, P., Ondrejka, C., Vinge, V.: The Potential of End-User Programmable Worlds: Present and Future. In: Panel SIGGRAPH ’07: ACM SIGGRAPH 2007 panels (2007)Google Scholar
- 8.Ruthruff, J.R., Burnett, M.: Six challenges in supporting end-user debugging. ACM SIG-SOFT Software Engineering Notes 30(4), 1–5 (2005)CrossRefGoogle Scholar
- 9.McDonald, M., Rogers, B.: Key Account Management – Learning from supplier and customer perspectives. Butterworth Heinemann, Oxford (1998)Google Scholar
- 10.Meyer, R.M., Masterson, T.: Towards a better visual programming language: critiquing prograph’s control structures. The Journal of Computing in Small Colleges 15(5), 181–193 (2000)Google Scholar
- 11.Millman, A.F., Wilson, K.J.: From Key Account Selling to Key Account Management. Journal of Marketing Practice: Applied Marketing Science 1(1), 9–21 (1995)CrossRefGoogle Scholar
- 12.Mørch, A.I., Stevens, G., Won, M., Klann, M., Dittrich, Y., Wulf, V.: Component-Based Technologies for End-User Development. Communications of the ACM 47(9), 59–62 (2004)CrossRefGoogle Scholar
- 13.Myers, B.A., Burnett, M.: End Users Creating Effective Software. CHI 2004 Special Interest Group, Vienna, Austria (2004)Google Scholar
- 14.Myers, B., Burnett, M.M., Wiedenbeck, S., Ko, A.J.: End User Software Engineering: CHI’2007 Special Interest Group Meeting. In: CHI 2007, San Jose, California, USA (2007)Google Scholar
- 15.Pendse, N.: What is OLAP?, The OLAP Report (1998), http://www.olapreport.com/fasmi.htm (visited: 13.03.2008)
- 16.Scaffidi, C., Shaw, M., Myers, B.: An Approach for Categorizing End User Programmers to Guide Software Engineering Research. In: First Workshop on End User Software Engineering (WEUSE I), Saint Louis, Missouri (May 21, 2005)Google Scholar
- 17.Scaffidi, C.: A Data Model to Support End User Software Engineering. In: 29th International Conference on Software Engineering, ICSE’07 Companion (2007)Google Scholar
- 18.Sidow, H.D.: Key Account Management. mi-Fachverlag, Landsberg am Lech (2007)Google Scholar
- 19.Qt, Nokia (2010), http://qt.nokia.com/ (visited: 18.01.2010)