Loading…
POWERUp 2019 has ended
Experience the magic of education. 
Tuesday, May 21 • 4:00pm - 5:00pm
37AL OLAP (Online Analytical Processing) Functions – Much More than Running Numbers!

Log in to save this to your schedule and see who's attending!

The first OLAP Functions were already introduced with Release 6.1, for building running numbers and ranks, in a specific sequence and even with the ability to restart numbering at a predefined level. At release 7.3 a bunch of additional OLAP functions and enhancements for existing OLAP functions are introduced. With these enhancements it is possible to easily build running totals or averages with or without level breaks. Data cannot only be accumulated over all rows, but also within a specific range. It is easy to access and compare the first, previous, next or last occurrence of the data within a partition. This session will give you an overview over the available OLAP functions and how they can be exploited.

Learning Objectives:Dissecting In this session you will learn which OLAP functions are available and how they can be used for and how they can be exploited especially for statistical reports.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Engineer, Toolmaker Advanced Efficiency GmbH
Application Modernization, Database Modernization, EducationSQL Queries, Database Design,SQL Programming, User Defined Functions and Table Functions,Journaling and Commitment Control,SQL Performance and Performance AnalysisRPG Free Format, ILE Concepts, Modular Programming, Data IntoXML... Read More →


Tuesday May 21, 2019 4:00pm - 5:00pm
Fantasy Tower North Ballroom A
  • Level Advanced
  • Operating System IBM i
  • Audience Manager, Programmers, Database Administrators and Engineers who need to generate and analyze complex statistics or everybody who is just interested in what is possible with OLAP functions.

Twitter Feed