Bud Endress, Director of Product Management, OLAP Option to the Oracle Database, has published a demo video of Microsoft Excel PivotTables connecting with Oracle 11g cubes. Connectivity is made possible using Simba's MDX Provider for Oracle OLAP data driver. Bud shows that the connectivity is seamless. The video is also great if you want to get an idea of the power of Excel PivotTables for business intelligence against multi-dimensional data.
Oracle has also posted an Oracle by Example tutorial, "Using Microsoft Excel with Oracle 11g Cubes" at: http://tinyurl.com/27fsfsu
The tutorial covers how to use Excel 2007 with Oracle 11g OLAP data for ad hoc query and analysis.
Posted by: Jay Elliott | 11/17/2010 at 02:56 PM