Hoping to offer greater flexibility for online analytical processing (OLAP) analysis, IBM next week will introduce the latest version of its DB2 OLAP Server with support for both relational and multidimensional data.
"The main point with this release is giving customers more choice at install time to choose either Hyperion's Essbase or DB2 for their data storage," Jeff Jones, program manager for data management marketing at IBM software solutions in San Jose, California, said on Monday.
To accommodate that choice, DB2 OLAP Server will ship with both IBM's DB2 Universal Database (UDB) Version 6.1 and Hyperion's Essbase engine. According to Jones, the inclusion of DB2 UDB 6.1 is evidence of IBM's commitment to building analytic functions into its database engine.
"We're moving towards but not completely to the state when the database engine includes all the analysis capabilities," said Jones.
In addition to flexibility in data storage, the new version of DB2 OLAP Server will offer 32-bit integration with Excel and Lotus 1,2,3; load improvements and calculation performance enhancements; query optimisation; and security enhancements. Version 1.1 will also include drill-through capabilities to integrate data from other sources into OLAP cube for better integration with Hyperion's solution.
IBM will announce OLAP Server Version 1.1 next Tuesday, and expects to ship the product by the end of the month. Pricing will not be available until that time.