As a ColdFusion developer, you are no doubt frequently asked for Web-based
reports on data such as sales, site hits, project metrics, and other
important business information. Users often want features such as the ability
to filter or sort by any column, to drill down into the data, or to
re-arrange the report to their liking. These can be time-consuming tasks for
developers to implement.
This is where Online Analytical Processing (OLAP) comes in. OLAP is a
technology for accomplishing all of the above tasks with ease. It is a data
engine designed to analyze multidimensional data sets such as sales totals
over product family, geographical region, and time period. If you've ever
created a pivot table in Excel, then you already understand the basic model
of OLAP, as pivo... (more)