Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
Database Tools
SQL Scripts & Samples
» Database Forum
» Sitemap
Free Newsletters:
News Via RSS Feed

follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2

Posted May 7, 2010

Oracle Database 11g OLAP Option for Ad Hoc BI Tutorial

By Staff

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.

View Article

Daily News Archives

Comment and Contribute


(Maximum characters: 1200). You have characters left.