Accessing OLAP Server Data with ADO .NET

This article has been excerpted from book "A Programmer's Guide to ADO.NET in C#".

The ActiveX Data Object Multi-Dimensional Library (ADOMD) provides access to Online Analytical Processing (OLAP) Server data from applications. OLAP services extract, summarize, organize, and store data warehouses in multidimensional structure, also known as OLAP server cubes.

To test the OLAP sample, I'll use the FoodMart 2000 database that comes with the Microsoft SQL Server Analysis Server. Before testing this sample, you must have SQL Server 2000 Analysis Server running. If you don't have SQL Server 2000 Analysis Server running, you can install it from Microsoft SQL Server CD by selecting SQL Server 2000 Components > Install Analysis Services. This option will install SQL Server Analysis Service on your machine.

Read more...