The Business Intelligence Guide
   BI Strategy | BI Program | BI Projects | BI Data | BI Infrastructure | BI User Tools | BI Vendors | Resource Guides | Articles | BI Blog | BIG Bookstore

Get a FREE Sample of the
The Total BI Guide
THE LOGICAL ORGANIZATION

and receive the
TLO NEWSLETTER
Just enter your details below

Email:
Name:
 
HOME
 
Business Intelligence
BI Strategy
BI Program Guide
BI Tools
- Dashboards
- Scorecards
- Operational BI
- Analytics
BI Software Solutions
Data Management
Databases
DataWarehouses
Decision Support
Marketing Tools
Industry Solutions
Case Studies
BI Surveys & Awards
RESOURCES
ARTICLES
BI EVENTS
BI NEWS
Sitemap

About the Author

View Gail La Grouw's profile on LinkedIn

Google+ Gail La Grouw

Bookmark and Share

Ad Hoc Query & Analysis


Ad Hoc Query and analysis uses relational OLAP tools to query a database to answer a particular question. Using slice-and-dice techniques, the entire database can be interrogated down to the lowest level transaction.

Ad Hoc Query and Analysis enables true investigative analysis of enterprise data, where 'what is happening' cannot be determined soley by predefined comparisons within a cube. The user may run a parameterized, or answer a prompted set of questions, to create an ad hoc report.

From this ad hoc report, the user can drill down into underlying reports until they find the answer to their question.

The results of the analysis, and the reports can be sent to other parties to collaborate on determing the impact of the issue and identify an appropriate resolution.

 

Appropriate tools are a critical factor in any Performance Management System and using the right tool for the right purpose, is a key enabler.

Ad Hoc Query and Analysis is designed for BI power users to interrogate all enterprise data using any
combination of data. It extends from the limits of pre-defined reports to allow users to assemble any possible combination of data into a report.

Some cube-based BI applications only allow users to create ad hoc reports against the small subsets of data available in their proprietary cube databases. This is not true ad hoc reporting.

Full Ad Hoc Query and Analysis is founded on Relational OLAP technology that allows users to perform full OLAP analysis against an entire relational database.

Typical features include:

  • Parameter-driven Reporting Using Guided Analysis – reports are compiled by answering a series of questions [prompts] prior to running the report
  • Drill Anywhere – using OLAP functionality to surf to any part of the database following the business model of the data warehouse.
  • OLAP Analysis Against the Entire Database – to conduct report manipulations.
    Filtering Sets – used to segment data according to different business criteria to refine the data set.
  • User-defined Data Grouping – to refine the business model without causing any changes to the database or the overall business model.

NEXT: Data Mining

 

Back To Top

Find Out About Our Leading Executive Guide To BI Strategy, Program & Technology


BI Tools Index | Advanced Analytics | OLAP | Cube Analysis | Ad Hoc Query Analysis | Data Mining | Alerting | Scorecards | Dashboards | Using A Dashboard | BI in BPM | MS Excel | Text Mining

Bookmark and Share
 


BI STRATEGY GUIDE

Proven Pathways to Success with Business Intelligence

IMPROVING BI ROI
BI Strategy Guide

Now Also Available in
EBOOK VERSION

Find out more