Oracle Database 11g OLAP Option for Ad Hoc BI Tutorial

Friday May 7th 2010 by DatabaseJournal.com Staff
Share:

Using Oracle database 11g OLAP data with Microsoft Excel tutorial is released on Oracle’s Technology Network.

Oracle’s 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 Simba’s MDX Provider for Oracle OLAP data connectivity product.

Simba’s 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 Excel’s ad hoc query and analysis and Excel’s 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.

Share:
Home
Mobile Site | Full Site
Copyright 2017 © QuinStreet Inc. All Rights Reserved