Vancouver, BC – May 6, 2010 – Simba Technologies Inc., industry’s choice for standards-based relational and multi-dimensional data connectivity, announced today that Oracle’s Technology Network has released an Oracle By Example (OBE) tutorial covering how to use Microsoft Excel 2007 with Oracle 11g OLAP data for easy and powerful ad hoc query, analysis and reporting. The direct Excel to Oracle connectivity is made possible by Simba’s MDX Provider for Oracle OLAP data connectivity product.
Simba’s MDX Provider for Oracle OLAP allows users to use the powerful and popular ad hoc query and analysis capabilities of Microsoft Excel PivotTables and PivotCharts with their Oracle OLAP business intelligence data. PivotTables provide cross-tab functionality to comprehensively present data in order to answer complex analytical questions. PivotCharts provide visual insight and reporting in a powerful, dashboard-like manner.
Simba’s MDX Provider for Oracle OLAP is a client-side driver that leverages Excel’s strengths for ad hoc query and analysis, as well as new Excel 2007 functionality based upon the latest advances in the multi-dimensional (MDX) query language data standard.
Simba’s MDX Provider for Oracle OLAP natively connects Microsoft Excel with Oracle 11g OLAP Option. It works seamlessly to parse and process multi-dimensional queries from Excel and integrate with Oracle OLAP via SQL/ODBC.
Using the Oracle11g OLAP sample data schema, participants will create an Excel 2007 report to analyze year-end Sales for calendar year 2009, with the objective of finding product dimension members that are underperforming, as compared to the prior year.
To achieve this objective, participants will:
- View stored, calculated and custom OLAP measures broken out by the appropriate dimension members,
- Use hierarchical navigation to drill through the data,
- Apply basic report formatting options to enhance the clarity of the report, and
- Apply visualization tools to the data using conditional formatting to reveal important information that otherwise may not be readily obvious.
Participants will further analyze the data using interactive ad hoc query techniques to discover trends in the data from a regional perspective. Finally, participants will create a simple business intelligence dashboard by adding a chart to the report.
Links and Additional Information
To view the tutorial, visit: http://www.oracle.com/technology/obe/11gr2_db_prod/bidw/olap11g_excel/olap_excel.htm
For more information about MDX Provider for Oracle OLAP, visit: http://www.simba.com/MDX-Provider-for-Oracle-OLAP.htm
To request a free evaluation of MDX Provider for Oracle OLAP, visit: http://www.simba.com/evaluate-MDX-Provider-for-Oracle-OLAP.htm
About Simba Technologies Inc.
Simba Technologies Inc. (http://www.simba.com) is the recognized world leader in standards-based data access products, solutions and services for both relational and multi-dimensional data sources. Simba delivers data connectivity and interoperability solutions to many of the world’s leading companies on various platforms, including Windows, Mac, UNIX and Linux. Simba’s best-in-class products support multiple interfaces, including ODBC, JDBC, OLE DB, OLE DB for OLAP (ODBO), XML for Analysis (XMLA), ADO, ADO.NET, ADOMD, and ADOMD.NET. Simba’s software is used worldwide. Its customers include leading independent software vendors and global enterprises like Oracle®, Microsoft®, Infor® and SAP® AG.
Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other company and product names may be trademarks of their respective owners.