OLAP Using ASP.NET - Accessing OLAP

(Page 6 of 7 )

This sample web application uses the existing demonstration database named "Foodmart 2000", which gets automatically installed by SQL Server 2000 Analysis Services (please refer to the previous topic).
This sample application was tested using the following software setup:

• Microsoft Windows 2000 Server
• Microsoft SQL Server 2000 Standard Edition
• Microsoft SQL Server 2000 Analysis Services
• Microsoft Visual Studio.NET 2003 Enterprise Architect

The .NET Framework doesn't natively support data access for multidimensional (i.e., OLAP) data sources. So, OLAP developers have to use existing COM-based ADO MD (Multi Dimensional) for application development. Programming with ADO MD is much like programming with ADO. Like ADO, ADO MD has two primary ways of retrieving information: You can retrieve metadata from the schema rowsets, or you can execute queries.

To start programming with ADO MD from Visual Studio .NET, you need to import the ADO MD type library into your .NET project. You can do this the same way you add a reference in Visual Basic (VB) 6.0. In Visual Studio .NET, open the Project menu and select Add Reference. In the resulting dialog box, click the COM tab and scroll down to select Microsoft ActiveX Data Objects (Multi-dimensional) 2.x Library (as shown in the following figure). After you've selected the type library, click Select, and then click OK. You've added the type definitions from the library to your project.

Next: All The Code >>
 

More ASP.NET Articles
More By Jon Jagger

Comments On: OLAP Using ASP.NET

· The article is very good for beginner to introduce about OLAP and using OLAP with...   >>> Post your comment now!