Resources and News

XMLA Specification

XML for Analysis Specification, Version 1.1 [doc]. Published by Microsoft Corporation and Hyperion Solutions Corporation. Updated: 11/20/2002


Business Intelligence (BI) with SQL Server 2005Microsoft presents a series of events and webcasts to provide in depth knowledge for developing and implementing adaptive BI application architecture. Click here for list of presentations.


Simba Technologies’ CEO Corner – Simba Technologies’ CEO shares his insight and experience on data connectivity and the fast paced environment of a technology company. This Blog contains posts on XMLA.


Wikipedia information on XML for Analysis. is an independent research resource for organizations buying and implementing OLAP applications. is a comprehensive resource website that provides readers with news, features and special reports covering all aspects of Business Intelligence.

MSDN’s OLE DB Programmer’s Reference describes the functional advantages of using OLE DB for OLAP to access multidimensional and relational databases.

“MDX Solutions: with Microsoft SQL Server Analysis Services 2005 and Hyperion Essbase, Second Edition” (paperback), by George Spofford, Sivakumar Harinath, Christopher Webb, Dylan Hai Huang, Francesco Civardi. ISBN: 0-471-74808-0

Articles and News

“MDX: Why it will matter to application developers,” by Mark Whitehorn, REG Developer, October 22, 2007.

“Simba Technologies Launches MDX SDK for Building Java-Based XMLA Providers for OLAP Solutions,” July 31, 2007.

“Dimensional Relational vs. OLAP: The Final Deployment Conundrum,” by Ralph Kimball, Intelligent Enterprise, April 27, 2007.

“Simba Technologies Releases Updated OLE DB for OLAP (ODBO) to XML for Analysis (XMLA) Bridge,” March 20, 2007.

“Simba Releases Updated MDX SDK – SimbaProvider SDK 4.0 Incorporates Enhanced MDX Capable of Connecting with Excel 2007 Pivot Tables,” February 13, 2007.

“Microsoft SQL Server 2005: Using SQL Server 2005 Reporting Services with Hyperion Essbase, SQL Server Technical Article,” by Travis Zhijin Wang and Richard Mao, December, 2006.

“Simba Technologies Set to Support Microsoft Excel 2007 Pivot Tables MDX Language Connectivity in SimbaProvider OLE DB for OLAP and XML for Analysis SDK,” September 19, 2006.

“Microsoft’s Performance Management Powerplay,” by Stephen Swoyer, TDWI, June 7, 2006.

“With Next-Gen Office, Microsoft’s BI Ambitions Soar,” by Stephen Swoyer, TDWI, May 31, 2006.

“Pentaho and Simba Technologies Partner to Bring World’s Most Popular Open Source OLAP Project to Microsoft Excel Users,” May 25, 2006.

“New Features in SQL Server 2005 SP1,” by Brian Moran, SQL Server Magazine, May 2006.

“Using SQL Server 2005 Reporting Services with SAP NetWeaver Business Intelligence,” by Richard Mao, Simba Technologies Inc., April 2006.

“ODBO, BAPI and XMLA – It’s All MDX to Me,” by Amyn Rajan, George Chow and Darryl Eckstein, Simba Technologies Inc., March 2006.

“The Fastest MDX/ODBO/XMLA Data Connectivity Kit Just Got Better” Simba Technologies releases SimbaProvider SDK 3.5, the latest version of its leading Software Development Kit (SDK) for building robust OLE DB for OLAP (ODBO) and XML for Analysis (XMLA) data connectivity to multi-dimensional OLAP and star schema relational data sources. SimbaProvider SDK 3.5 includes Simba’s new, next generation MDX parser, which is capable of synthesizing major MDX variants and handling MDX generated by most of today’s multi-dimensional applications.

“Connecting to SAP BW from ASP Using ADO MD,” by Amyn Rajan, Dermot MacCarthy and Bruce Johnston, Simba Technologies Inc., June 2005.

“A Jump Start to SQL Server BI,” by Don Awalt, Larry Barnes, Alexei Bocharov, Herts Chen, Rick Dobson, Rob Ericsson, Kirk Haselden, Brian Lawton, Jesper Lind, Tim Ramey, Paul Sanders, Mark D. Scott, David Walls, and Russ Whitney, WindowsIT Pro, 2005.

“Connecting to SAP BW Using Visual Basic and ADO MD,” by Amyn Rajan, Dermot MacCarthy and Bruce Johnston, Simba Technologies Inc., May 2005.

“Connecting to SAP BW with Excel PivotTables and ODBO,” by Amyn Rajan, Bruce Johnston and Dermot MacCarthy, Simba Technologies Inc., March 2005.

“Julian Ford on Using BI Beans with an XMLA Provider,” by Julian Ford, via Mark Rittman’s Oracle Weblog, February 2005.

“XML for Analysis: Marrying OLAP and Web Services, Move your analytical applications to a flexible, Web-based architecture,” by Rob Ericsson, SQL Server Magazine, November 2004.

“A New View on Intelligence, Given the growth of XML and the advantages of EII, more companies will change their view of on-demand intelligence,” by Tim Matthews, Intelligent Enterprise, July 19, 2004.

“MDX(-Ray) of Excel, Use logging to reveal your expressions’ inner workings and boost your MDX knowledge,” by John Lynn, SQL Server Magazine, June 2004.

“Financial Reporting with Analysis Services, OLAP lets end users drill down for report details,” by Yoram Levin, SQL Server Magazine, April 2004.

“Relating to OLAP, OLAP and ROLAP are a continuum, not competitors,” by Joy Mundy, Intelligent Enterprise, October 8, 2002.

“Access to Intelligence, The New OLAP APIs,” by George Spofford, Intelligent Enterprise, September 17, 2002.

“Distributed Decision Support, Are grids a good step – or even a likely one – for mainstream decision support?,” by Seth Grimes, Intelligent Enterprise, September 17, 2002.

“The Ongoing Evolution of BI Web Services, A new SDK from Cognos Inc. shows Web services are evolving for business intelligence,” by Philip Russom, Intelligent Enterprise, August 21, 2002.

“Commentary: OLAP API wars,” by Nigel Pendse, The OLAP Report, April 26, 2002.

“Picking A Winner, BI vendors ponder new XML for Analysis and Java for OLAP technologies,” by Nelson King, Intelligent Enterprise, October 4, 2001.

“XML for Analysis Decoded, The XML for Analysis API has snared widespread support. But will the big fish slip through the .Net in favor of Java and proprietary APIs?,” by Seth Grimes, Intelligent Enterprise, August 31, 2001.

“The Microsoft Momentum Continues, XML standards and ProClarity’s tools keep analysis opportunities rolling,” by Mark Smith, Intelligent Enterprise, April 25, 2001.