Articles & Content


E13 - OLAP Queries for Powerful Reporting and Analytics

Topic: Cross Platform DB2 for z/OS & LUW

Subtopic: 2013

OLAP expressions are an extremely powerful tool in SQL that enable advanced reporting features, such as ranking, counting, averaging, adding, etc. within a set of data processed in an SQL statement. This feature allows for data to be aggregated based upon values in a query in a manner very similar to coding control breaks in a program process. This allows for entire programs, or even applications, to be replaced my much more flexible and portable SQL statements. Reduce programming time and complexity, and improve flexibility and performance, by deploying OLAP expressions. This session will show you how!

Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.