DB2 Cube Views Getting Started With MicroStrategy

Multidimensionality is the primary requirement for an OLAP system, and the cube always refers to the collections of the data that an OLAP system implements.

Business Intelligence and OLAP systems are no longer limited to the privileged few business analysts: they are being democratized by being shared with the rank and file employee demanding a Relational Database Management System (RDBMS) that is more OLAP-aware.

IBM DB2 Cube Views V8.1 (DB2 Cube Views through the Redpaper) and its cube model provides DB2 Universal Database (DB2 through the Redpaper) the ability to address multidimensional analysis and become an actor in the OLAP world, as detailed in the IBM Redbook, DB2 Cube Views: A Primer, SG24-7002.

This Redpaper documents the metadata bridge from DB2 Cube Views to MicroStrategy and will help DB2 database administrators and Business Intelligence architects understand and evaluate its benefits in their own Business Intelligence and OLAP system environment.

• Leveraging DB2 Data Warehouse Edition for Business Intelligence, SG24-7274-00
• TCP/IP Tutorial and Technical Overview, GG24-3376-07
• WebSphere MQ V6 Fundamentals, SG24-7128-00

Publish Date
05 September 2003

Rating:
(based on 2 reviews)

Rate this paper

Author(s)

Corinne Baragoin is a Business Intelligence Project Leader at the International Technical Support Organization, San Jose Center. She has over 17 years of experience as an IT specialist on DB2 UDB and related solutions. Before joining the ITSO in 2000, she worked as an IT Specialist for IBM France, supporting Business Intelligence technical presales activities and assisting customers on DB2 UDB, data warehouse and OLAP solutions.

• Corinne Baragoin

Ricardo Arriaga is a Senior Beta Consultant in Technology Services at MicroStrategy Inc. headquarters in the USA. He has 3.5 years of experience in MicroStrategy's products quality assurance testing. He has worked ensuring the quality, functionality and usability of the product, performing various intensive testing at MicroStrategy's top customers sites. He has worked developing documentation material, provided training for new products and assisted presales activities. He holds a degree in B.S. Electronic Engineering from the Instituto Tecnol—gico y de Estudios Superiores de Monterrey (ITESM-CEM), Estado de MŽxico.

• Ricardo Arriaga

Cuong Bui is a Program Manager at MicroStrategy, Inc. in Washington, DC. He oversees the technical direction of the MicroStrategy Intelligence Server product. He has 4.5 years of experience in Business Intelligence and Data Warehousing. He holds a Master's degree from the Massachusetts Institute of Technology and a Bachelor's degree from Ecole Centrale Paris.

• Cuong Bui

Annie Neroda is a Senior Consulting Software IT Specialist in the USA. She has 35 years of experience in IT field. She holds a degree in Mathematics from Trinity College in Washington, DC. Her areas of expertise include Business Intelligence, especially OLAP, ETL and Data Mining. She has taught extensively on DB2, Business Intelligence and Data Warehousing.

• Annie Neroda

IBM Form Number
REDP-3715-00