Welcome!

Mark Murphy

Subscribe to Mark Murphy: eMailAlertsEmail Alerts
Get Mark Murphy via: homepageHomepage mobileMobile rssRSS facebookFacebook twitterTwitter linkedinLinkedIn


Top Stories by Mark Murphy

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)