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 SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
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 DatabaseJournal.com 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.