Business intelligence is essentially a set of best practices for building models to answer business questions. However, today's BI best practices may be suboptimal for many enterprises' decision-support requirements.

For most users, BI is a journey that's been modeled and mapped out in advance by others, following a well-marked path through vast data sets. Data models, which must often be pre-built by specialists, generate or shape the design of such key BI artifacts as queries, reports and dashboards. Essentially, every BI application is some data modeler's prediction of the types of questions that users will want to ask of the underlying data marts. Sometimes, those predictions are little more than an educated guess -- and are not always on the mark.

BI's most ubiquitous data-modeling approach is the online analytical processing (OLAP) data structure known as a "cube." The OLAP cube -- essentially a denormalized relational database -- sits at the heart of most BI data marts. OLAP cubes, usually implemented as multidimensional "star" or "snowflake" schemas, allow large recordsets to be quickly and efficiently summarized, sorted, queried and analyzed.

However, no matter how well designed the dimensional data models within any particular cube, users eventually outgrow these constraints and demand the ability to drill down, up and across tabular record sets in ways not built into the underlying data structures.

The chief disadvantage of multidimensional OLAP cubes is their inflexibility. Cubes are built by pre-joining relational data tables into fixed, subject-specific structures. One way of getting around these constraints is the approach known as relational OLAP, which retains the underlying normalized relational storage approach while speeding multidimensional query access through "projections." However, relational OLAP also suffers from the need for explicit, upfront modeling of relationships within and among the underlying tabular data structures.

From the average user's point of view, all of this is mere plumbing -- invisible and boring -- until it prevents them from obtaining the new query tools, structured reports and dashboards needed to do their jobs. One unfortunate consequence of OLAP cubes' inflexibility is that requests for new BI applications inevitably wind up in a backlog of IT projects that can take weeks or months to deliver.