DB2 Universal Database provides powerful tools for business analysis, including online analytical processing (OLAP) tools.
DB2 Universal Database provides you with integrated online analytical processing capabilities through the DB2 OLAP Starter Kit. It allows users to easily define multidimensional applications. The applications can be linked and populated with warehouse data, and shared among a work group. The Starter Kit prepares you for more complex OLAP applications which require the full function DB2 OLAP Server product.
The Starter Kit is based on the DB2 OLAP Server product and Hyperion's industry-leading Essbase technology.
New SQL functions for moving aggregates, such as moving average and moving sum (for example, the balance column of a bank statement), are now available for analytical queries. These additional computational functions expand your OLAP capabilities and improve the performance of these typically challenging queries.