DB2 OLAP Server

When you create a warehouse, you prepare data for your business users to analyze. IBM provides powerful tools for that analysis, including online analytical processing (OLAP) tools. DB2 OLAP Server lets you apply OLAP techniques to your DB2 data for fast, intuitive multidimensional analysis. With the many applications, tools, and solutions providers who support DB2 OLAP Server, you can create your own applications or have turnkey solutions built for you.

DB2 OLAP Server allows users to ask questions intuitively because the OLAP data is presented in business dimensions. OLAP can perform analyses such as: "Display the profit of my highest and lowest performing products last quarter in my domestic sales regions."

DB2 OLAP Server is based on Hyperion Essbase, the market-leading OLAP technology from Hyperion Solutions. With DB2 OLAP Server, your primary tool for creating OLAP applications is the DB2 OLAP Integration Server, which runs on top of the Essbase multidimensional server and DB2 Universal Database. With applications created with the DB2 OLAP Server, users can easily analyze DB2 data using Lotus 1-2-3 or Microsoft Excel.