Articles & Content

Archives

Experiences with DB2 Cubing Services (D10)

Topic: 2009 NA

Subtopic: DB2 for LUW



DATE: 2009-5-14 (01:30 PM - 02:30 PM)
SPEAKERS: Philip Nelson (ScotDB Ltd./ Scottish Widows PLC)

This presentation describes how we used DB2 Infosphere Warehouse (formerly DB2 Data Warehouse Edition) to enable Microsoft Reporting Services to access our DB2-based Data Warehousing Infrastructure. In particular it looks at using DB2 Cubing Services as an alternative to Microsoft Analysis Services as an MDX data source.It discusses the benefits and drawbacks of the DB2-based solution.

EXP. LEVEL: Intermediate,Advanced

OBJECTIVES:

Introduction to the MDX (MultiDimensional Expressions) query language

The components of the two BI solutions : all Microsoft and hybrid Microsoft / IBM.

Building a Data Warehouse using the Infosphere Warehouse tooling

Building multidimensional "cubes" with DB2 Cubing Services

Benefits and Drawbacks of using IBM Infosphere Warehouse with Microsoft Reporting Services



Click Here to Download

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