In this lesson, you will explore the concepts of creating applications you can use to analyze relational data using Online Analytical Processing (OLAP) techniques. You will use the DB2 OLAP Starter Kit, a scaled-down version of the full-function DB2 OLAP Server product. Both the DB2 OLAP Starter Kit and DB2 OLAP Server are based on OLAP technology from Hyperion Solutions.
Within the DB2 OLAP Starter Kit, your primary tool for creating OLAP applications is the DB2 OLAP Integration Server, which runs on top of the Essbase multidimensional server. With these applications, users can analyze DB2 data using Lotus 1-2-3 or Microsoft Excel.