Multidimensional Analytics: Delivered with InfoSphere Warehouse Cubing Services

An IBM Redbooks publication

Published 27 April 2009

cover image

ISBN-10: 0738432628
ISBN-13: 9780738432625
IBM Form #: SG24-7679-00
(276 pages)

More options

Rate and comment

Authors: Chuck Ballard, Silvio Ferrari, Robert Frankus, Sascha Laudien, Andy Perkins, Philip Wittann


In this IBM Redbooks publication, we discuss and describe a multidimensional data warehousing infrastructure that can enable solutions for complex problems in an efficient and effective manner. The focus of this infrastructure is the InfoSphere Warehouse Cubing Services Feature. With this feature, DB2 becomes the data store for large volumes of data that you can use to perform multidimensional analysis, which enables viewing complex problems from multiple perspectives, which provides more information for management business decision making. This feature supports analytic tool interfaces from powerful data analysis tools, such as Cognos 8 BI, Microsoft Excel, and Alphablox.

This is a significant capability that supports and enhances the analytics that clients use as they work to resolve problems with an ever growing scope, dimension, and complexity.

Analyzing problems by performing more detailed queries on the data and viewing the results from multiple perspectives yields significantly more information and insight. Building multidimensional cubes based on underlying DB2 relational tables, without having to move or replicate the data, enables significantly more powerful data analysis with less work and leads to faster problem resolution with the capability for more informed management decision making.

This capability is known as No Copy Analytics and is made possible with InfoSphere Warehouse Cubing Services.

Table of contents

Chapter 1. Introduction
Chapter 2. A multidimensional infrastructure
Chapter 3. The relational multidimensional model
Chapter 4. Cubing services model implementation
Chapter 5. Reporting solutions
Chapter 6. Cubing services performance considerations
Chapter 7. InfoSphere Warehouse on System z: Cubing Services

Follow IBM Redbooks

Follow IBM Redbooks