Multidimensional Analytics: Delivered with InfoSphere Warehouse Cubing Services

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.

thumbnail 

Published on 27 April 2009

  1. .EPUB (10.0 MB)
  2. .PDF (18.7 MB)

Google Play Books
Share this page:   

ISBN-10: 0738432628
ISBN-13: 9780738432625
IBM Form #: SG24-7679-00


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

    menu icon

    Abstract

    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

     

    Others who read this also read