Skip to main content

End User Development for OLAP – A Scenario from Food Industry

  • Conference paper
Perspectives in Business Informatics Research (BIR 2010)

Part of the book series: Lecture Notes in Business Information Processing ((LNBIP,volume 64))

Included in the following conference series:

  • 696 Accesses

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

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)

    Article  Google 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)

    Article  Google 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)

    Article  Google 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)

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2010 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Gleichmann, M., Hasart, T., Bruder, I., Wolff, A. (2010). End User Development for OLAP – A Scenario from Food Industry. In: Forbrig, P., Günther, H. (eds) Perspectives in Business Informatics Research. BIR 2010. Lecture Notes in Business Information Processing, vol 64. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-642-16101-8_17

Download citation

  • DOI: https://doi.org/10.1007/978-3-642-16101-8_17

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-642-16100-1

  • Online ISBN: 978-3-642-16101-8

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics