An OLAP Requirements Example

Following is an abbreviated requirement that reflects an actual implementation that was done for a large Silicon Valley company. You will follow the mini-methodology as closely as possible to implement this requirement in AS, pointing out which facilities of AS should be used for which purpose along the way.

CompSales International

A large computer manufacturer named CompSales International needs to do basic analytical processing of its product data in a new DSS environment. The main business issues at hand are related to minimizing channel inventory and better understanding market demand for the company's most popular products. The detailed data processing requirements are as follows:

  1. View sales unit actuals and ...

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.