Articles & Content

Archives

MDX Tutorial Using Alphablox and Cubing Services (H09)

Topic: 2008 NA

Subtopic: Cross Platform DB2 for z/OS & LUW



DATE: 2008-05-21 (09:45 AM - 10:45 AM)
SPEAKERS: John Poelman (IBM Silicon Valley Lab)

Multidmensional Expressions, or MDX, is the de facto standard among query languages for OLAP databases. MDX has become to multidimensional data what SQL is for relational data: the query language of choice. As analytical applications becoming increasingly pervasive, use of MDX continues to grow. MDX is the query language of Cubing Services, the new OLAP cube server in InfoSphere Warehouse 9.5. Cubing Services and Alphablox (another InfoSphere Warehouse component) together provide comprehensive, embeddable analytical capabilities for your data in DB2. In this talk we will first give an overview of the analytic stack in InfoSphere Warehouse, with a focus on Cubing Services and Alphablox. Then we will dive into the basics of MDX and show you how to write your own powerful MDX queries to get the most from your analytic applications built with the InfoSphere Warehouse stack.

EXP. LEVEL: Beginner

OBJECTIVES:

What is DB2 Warehouse and what is its analytics stack? What is dynamic warehousing?

What is Cubing Services and how does it leverage DB2? How does it differ from DB2 Cube Views?

What is Alphablox all about? What is embedded or inline analytics?

What is the MDX query language and what can I do with it? How does it compare to SQL?

How much MDX do I need to know to build analytic applications with Alphablox and Cubing Services?



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.