In this article, I’ll demonstrate how to give web users the ability to search and group data via web reporting pages –- using good old web scripting and SQL Server. No ETL/OLAP tool needed. Before we begin, I need to explain data warehousing. In general, as raw transaction level data accumulates, we summarize the data into a different table. We create an “on-line analytical processing cube”. Web users can then query against this cube, w/o interfering with your actual data feed. Also, the cube contains summarized data, speeding up queries.
