Simbas MDX Provider for Oracle OLAP enables the use of ad hoc query and analysis capabilities of Microsoft Excel PivotTables and PivotCharts with Oracle OLAP BI data as well as making use of Excels ad hoc query and analysis and Excels new advances in multi-dimensional MDX query language data standard. With the tutorial users will view stored, calculated and custom OLAP measures, use hierarchical navigation for drilling down through data, apply report formatting options for report enhancement, and make use of visualization tools.
Using Oracle database 11g OLAP data with Microsoft Excel tutorial is released on Oracles Technology Network.
Oracles Technology Network has release an Oracle by example tutorial on using Microsoft Excel with the Oracle database 11g; showing how easy it is to perform BI analysis and reporting. Connectivity is made possible with Simbas MDX Provider for Oracle OLAP data connectivity product.