Loading…
Welcome to Common Europe Congress 2021 in Copenhagen, Denmark, the largest IBM Power Systems community gathering in Europe with in-depth workshops, deep dives, presentations. See the exciting agenda below; see more and register immediately: https://comeur.org/cec2021/ 
Back To Schedule
Sunday, October 31 • 10:00 - 13:00
Advanced SQL Queries: Multi-Dimensional Grouping and OLAP (Online Analytical Processing) Functions – Powerful Partners

Log in to save this to your schedule, view media, leave feedback and see who's attending!

Feedback form is now closed.
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. If we then combine those queries with the multi-dimensional grouping, i.e. the ability to generate all kind of sub-totals and totals, we can write a whole program/report with a single SQL Statement.

Speakers
avatar for Birgitta Hauser

Birgitta Hauser

Database and Software Architect


Sunday October 31, 2021 10:00 - 13:00 CET
F18 - Room 18