Managing Multidimensional Data Marts with Visual Warehouse and DB2 OLAP Server

TOP : DB2 Information Management

Managing Multidimensional Data Marts with Visual Warehouse and DB2 OLAP Server

This redbook will help you understand the concepts of multidimensional analysis and use the functions and features of IBMÆs DB2 OLAP Server together with IBM Visual Warehouse to build an end-to-end Business Intelligence solution for online analytical processing (OLAP).

The book provides valuable information for readers who are new to and readers who have experience with multidimensional data marts.

In Chapters 1 through 3 we establish the basic concepts and architectures and discuss guidelines for planning a Business Intelligence project. In Chapters 4 and 5, which are targeted to the novice, we provide step-by-step descriptions of how to implement a simple initial dimensional model with DB2 OLAP Server and Visual Warehouse. In Chapters 6 and 7 we introduce advanced topics, such as calculation options and partitioning techniques, which enable more complex and scalable models. In Chapters 8 through 11 we cover the topics that are important for managing a data mart environment for OLAP, such as updates and maintenance, performance and tuning considerations, problem determination, and security. In Chapters 12 through 16 we deal with aspects related to accessing the information stored in a multidimensional data mart. We cover spreadsheet access, SQL access, and Web-based analysis capabilities.
Price: $55.00 $44.00
Pages: 380
Date Published: September 9, 1999
ISBN: 0738412414
Author: IBM Redbooks
Product Number: SG24-5270-00
Ships in 3-5 days
Return to category
Why Vervante?

© 2024 Vervante Corporation. All rights reserved.