Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

58 Solving Operational Business Intelligence with InfoSphere Warehouse Advanced Edition

򐂰 IBM Cognos Framework Manager

This is the IBM Cognos BI modeling tool for creating and managing

business-related metadata for use in IBM Cognos BI analysis and reporting.

Metadata is published for use by reporting tools as a package, providing a

single, integrated business view of any number of heterogeneous data

sources. OLAP cubes are designed to contain sufficient metadata for

business intelligence reporting and analysis. Because cube metadata can

change as a cube is developed, IBM Cognos Framework Manager models

the minimum amount of information required to connect to a cube. Cube

dimensions, hierarchies, and levels are loaded at run time.

Figure 2-22 shows the browser interface to the Cognos BI tools provided.

Figure 2-22 IBM Cognos BI tools implemented within a browser interface

2.2.6 InfoSphere Warehouse Advanced Edition command-line tools

and utilities

InfoSphere Warehouse Advanced Edition comes supplied with a number of

products and utilities, which primarily function from the native operating system

command line of the system they are installed. For a Microsoft Windows

operating system, this is the DOS command line. For versions of Linux, it is the

bash command line. These command-line products and tools are listed here:

򐂰 DB2 Client

This is a set of bundled utilities and tools supplied as the client package for

IBM DB2 product set. It provides the functions and tools required to both

connect and work with DB2 relational databases installed on both local and

remote hardware servers. Many DB2 Client utilities, such has LOAD,

EXPORT, REGEN, and REORG, are made available to the ETL processes

from within both the DIS runtime and Design Studio through the direct calls to

the DB2 command line, because these functions cannot be executed using

SQL or a JDBC database connection.