PivotCharts provide visual insight and reporting in a powerful, dashboard-like manner. PivotTables provide cross-tab functionality to comprehensively present your data in order to answer complex analytical questions.
The Simba Technologies MDX Provider for Oracle OLAP allows you to use the powerful and popular ad hoc query and analysis capabilities of Microsoft Excel PivotTables® and PivotCharts® with your Oracle OLAP business intelligence data. This tutorial covers how to use Excel 2007 with Oracle11g OLAP data for easy and powerful ad hoc query and analysis.