To Next Page

To Previous Page

5486LPDb.fm Draft Document for Review October 18, 2004

612 IBM Eserver i5 and iSeries System Handbook

Solutions and benefits

DB2 OLAP Server can be used for management, reporting, analysis, modeling,

planning and data warehousing applications. Typical applications include Sales,

Profitability, Market share, Supplier Analysis, Executive Information System

(EIS), Financial consolidations, Budgeting, Forecasting, and Enterprise

performance measurement.

Relational Storage Manager is included with DB2 OLAP Server. The optional

features include:

򐂰 Currency Conversion: Converts financial data using any currency exchange

rate scenario.

򐂰 API: Lets you use standard tools to create custom DB2 OLAP Server

applications that take advantage of the powerful data storage, retrieval, and

analytical capabilities.

򐂰 Extended Spreadsheet Toolkit: Includes more than 20 macros and Visual

Basic functions, letting you build custom Lotus 1-2-3® or Microsoft Excel

applications that tightly integrate with DB2 OLAP Server.

򐂰 DB2 OLAP Server for iSeries Partitioning Option V8.1: Provides a

collection of powerful features that makes it easy to design and administer

multidimensional databases (cubes or star schemas) that span OLAP

applications or servers.

򐂰 DB2 OLAP Server for iSeries Builder V8.1: Builder assists in moving

enterprise data to the AS/400 by transforming and simplifying online

transaction data into meaningful information.

򐂰 Data distribution: Can distribute data from DB2 Distributed Relational

Database Access (DRDA) data sources other than the AS/400, including DB2

UDB running on OS/390, AIX 5L, and Windows NT.

Related products ESSBASE-Ready ISV Products

DB2 Data Warehouse Center and DB2 Warehouse Manager

DB2 Intelligent Miner™ for Data

Client code Packaged and delivered with server code separate from OS/400

Replaces product DB2 OLAP Server for AS/400, Version 7.1 (5686-OLP)

Further information http://www.ibm.com/software/data/db2/db2olap/

http://publib.boulder.ibm.com/html/as400/infocenter.html

http://www.redbooks.ibm.com

http://www-1.ibm.com/servers/solutions/bi/iseries/

DB2 OLAP Server for iSeries V8.1

IBM eserver i5 User Manual

Other manuals for IBM eserver i5