Saturday, March 7, 2009

Using Excel with Oracle OLAP

I did two webcasts about using Excel with Oracle OLAP this week. They were incredibly sucessful. If you've never looked at Excel 2007 pivot tables, I'll tell you that they are very good. Using the MDX Provider for Oracle OLAP, Excel makes a direct/native connection to the Oracle database and has the ability to query OLAP cubes in a multidimensional context.

I won't every try do to justice to this solution in this blog. It's really best to just see it in action. I've posted a video on (go to and click on the product demo link).

You can also sign up for the beta test at Do yourself a favor - try it out.

Querying an Oracle OLAP Cube using Excel.