IBM AS/400e, Руководство пользователя

Страница: 572 / 834

IBM Licensed Programs: Database Products
542
AS/400e System Handbook
programming interfaces of Hyperion Essbase with the IBM DB2 family of relational
databases.
DB2 OLAP Server features the same functional capabilities and interfaces as ShowCase
Essbase/400 Version 3.0 including:
• Multi-user read and write access
• Large-scale data capacity
• Analytical calculations
• Flexible data navigation
• Consistent and rapid response
• Dynamic calculation
• OLAP partitioning and replication
• Time series
• Linked reporting objects
The relational storage manager option of DB2 OLAP Server integrates the powerful DB2
relational technology and offers a number of functional characteristics that augment and
complement those it inherits from Hyperion Essbase. These include managing data using
standard tools and techniques familiar to any IT professional, accessing data using the widely
adopted Essbase interface, and industry-standard SQL. These attributes greatly enhance the
ability of a business to manage its information, and access it using whatever tools are
standard and popular among its business professionals.
DB2 OLAP Server for AS/400 can access AS/400 servers across all TCP/IP networks
connected to Windows and UNIX clients. It maintains and analyzes data stored in the
scalable DB2 Universal Database. DB2 OLAP Server for AS/400 Builder Version 1.1 assists
in moving enterprise data to the AS/400 system by transforming and simplifying online
transaction data into meaningful information. It easily builds data warehouses or data marts
using full SQL support. It selects specific data from one or more tables in an OLTP database
and moves them to existing tables or new tables created “on-the-fly”. It cleanses data by
calling user programs or by entering any SQL statement before or after the distribution.
DB2 OLAP Server for AS/400 includes a comprehensive set of graphical tools for database
management, security, and administration for deploying industrial-strength OLAP
applications. DB2 OLAP Server for AS/400 includes Hyperion Essbase Spreadsheet Add-in
and Hyperion Essbase Application Manager. The Spreadsheet Add-in is desktop software
that merges seamlessly with Microsoft Excel or Lotus 1-2-3, turning familiar spreadsheet
programs into a tightly integrated OLAP client for DB2 OLAP Server for AS/400. The Builder
Add-On program includes the Application Manager that lets the user easily build, modify, and
maintain analytical models, calculations, data access security, data loading rules, dimension
building, and system management functions.
DB2 OLAP Server for AS/400 operates on OS/400 operating systems over all leading
networks and can create and manage star schemas automatically in DB2 databases.