View all newsletters
Receive our newsletter - data, insights and analysis delivered to you
  1. Technology
  2. Data
September 21, 2010

Oracle, Simba Technologies unveil MDX Provider for Oracle OLAP

New release introduces support for Microsoft Excel 2010

By CBR Staff Writer

Oracle and Simba Technologies have announced the availability of MDX Provider for Oracle OLAP 2.0 for organisations using spreadsheets for business intelligence or reporting on data using Microsoft Office,

This new provider connects Microsoft Excel PivotTable cross-tab and dashboard functionality with OLAP data.

The MDX Provider for OLAP 2.0 introduces support for Microsoft Excel 2010, drillthroughs within Excel, visual slicers and sparklines that enable cell-level formatting with embedded micro-charts for visual trending analysis.

It also features integration with Excel Services 2010 or 2007 to store and share workbooks on Microsoft Sharepoint for collaboration.

In addition, it supports Excel 2007 and 2003 as well as Database 11g Release 2 and 1.

Oracle OLAP, an option to Database 11g Enterprise Edition, is a calculation engine that supports analytical applications including planning, budgeting, forecasting, sales, and marketing to help identify key business trends and model complex business scenarios.

Content from our partners
Unlocking growth through hybrid cloud: 5 key takeaways
How businesses can safeguard themselves on the cyber frontline
How hackers’ tactics are evolving in an increasingly complex landscape

Simba vice president of sales Suzanne Hoffman said that MDX Provider for Oracle OLAP is the de facto solution for integrating the OLAP option of Database 11g with Microsoft Excel and the rest of the Microsoft Office Suite.

"The solution directly connects the multi-dimensional ad hoc query, analysis and reporting capabilities of Excel PivotTables to the power and security of the Oracle Database without creating an additional tier. This drives user performance," Hoffman said.

Websites in our network
Select and enter your corporate email address Tech Monitor's research, insight and analysis examines the frontiers of digital transformation to help tech leaders navigate the future. Our Changelog newsletter delivers our best work to your inbox every week.
  • CIO
  • CTO
  • CISO
  • CSO
  • CFO
  • CDO
  • CEO
  • Architect Founder
  • MD
  • Director
  • Manager
  • Other
Visit our privacy policy for more information about our services, how New Statesman Media Group may use, process and share your personal data, including information on your rights in respect of your personal data and how you can unsubscribe from future marketing communications. Our services are intended for corporate subscribers and you warrant that the email address submitted is your corporate email address.