Back to Search Results

Training Course Summary:

Mixed class and practical course equips you to implement DB2 OLAP
Server ­ install the product, learn to define the data structure,
populate it with data, and use the supplied query and reporting tool.

Pre-Requisites:

Familiarity with PC applications
Basic knowledge of relational concepts (tables, views, joins and simple SQL)

Who Should Attend:

Technical specialists, including power users, developers, technical support personnel, database administrators, consultants and product specialists.

Training Course Overview/Content:

On completion you will be able to:
Describe terms used in OLAP
Describe the development of a multi-dimensional outline
Define outline dimensions using the Application Manager and Integration Services interfaces
Populate the outline using flat file data, SQL data and rules files
Use a simple CALC script and describe the impact of using dynamic calculations
Describe and discuss product installation
Use the product, with sample data, to implement typical business queries