Summary
This chapter discussed extensively the OLAP approach, OLAP terms, and the tools from Microsoft to enable OLAP cubes. It presented a mini-methodology to follow that should help you get an OLAP project off the ground and running smoothly. These efforts are typically not simple, and a well-trained data warehouse analyst or data architect is usually worth his weight in gold because of the end results (and value) that can be achieved with a good OLAP cube design.
Sometimes it is difficult to engage the end users and get them to use the OLAP cube successfully. Easy-to-use third-party tools can greatly help with this problem.
From an Analysis Services point of view, the ease of control of storage methods, dimension creation, degrees of aggregation, ...
Get Microsoft® SQL Server™ 2000 Unleashed, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
