Advanced Level Users.
Includes CD-ROM.
OLAP (online analytic processing) and data mining allow database users to consolidate and summarise large quantities of data residing in a data warehouse. OLAP also offers powerful analytical tools that can identify underlying trends within data.
Until recently, using OLAP required companies to spend from $50,000 to $500,000. SQL Server 2000, however, has integrated OLAP, called Analysis Services, allowing database users to get these services for the price of SQL Server. You don't even have to use SQL Server as your database to use its OLAP services.
This book is the most comprehensive and practical guide to OLAP with SQL Server 2000 and VB. The book covers advanced programming topics, such as querying cubes using MDX, building custom solutions with ADOMD, and tying into COM interfaces with DSO.