Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

Chapter 2. Overview of InfoSphere Warehouse Advanced Edition 19

2.1.7 IBM Cognos Business Intelligence for Reporting

Having a great data warehouse with many advanced features is irrelevant if you

cannot access and present this information in a concise and business-like

fashion. For this reason, InfoSphere Warehouse Advanced Edition includes

Cognos 10 Business Intelligence (BI) for reporting.

From professional report writers who need to produce hundreds of reports, to

rushed business users requiring an ad hoc report for the next sales meeting,

Cognos 10 BI provides the tools needed to produce detailed and accurate

reports, with access to near-real time data. The partnership between Cognos 10

BI and InfoSphere Warehouse server is fully demonstrated by the Cognos BI

server’s utilization of the OLAP cubing services, which provide a vast

performance boost to the production of business reports.

Included within the InfoSphere Warehouse Advanced Edition are both the

Cognos 10 BI server and Frameworks Client applications, allowing for the full

spectrum of an enterprise BI solution.

2.1.8 IBM Data Studio

The latest version of IBM Data Studio has been radically enhanced from its

humble beginnings to become an advanced solution for developing, managing,

and monitoring heterogeneous database environments. Although it is aimed at

increasing the productivity and collaboration of both database developers and

administrators, its ease of use and common platform also greatly support the

most casual of database users.

By utilizing the Eclipse Workbench Platform, IBM Data Studio becomes both an

extendible environment (through the use of plug-ins) and a familiar Integrated

Development Environment (IDE), not just for database developers but also for

those working with Java, PHP, and Perl.

IBM Data Studio has been extended to include the functionality of both

InfoSphere Optim Development Studio and Database Administrator, and Data

Studio Health Monitor. This in turn removes the need for multiple tools and

reduces complexity and support issues.

Advanced integration points with other IBM tools such as Rational® Application

Developer, InfoSphere Data Architect, and InfoSphere Optim pureQuery™

Runtime support a collaborative working environment.

The latest DB2 capabilities including adaptive compression, time travel query,

row and column access control, and multi-temperature data management are all

supported within IBM Data Studio, as is the functionality to develop and test user