Articles & Content
Topic: 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
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.