On Accessing Data From An OLAP Server Using MS Excel
(Page 1 of 6 )
Have you ever wondered how to access data for an SQL 2000 Analysis server from Microsoft's Excel program? This article will show you a step-by-step procedure.
The main objective of this article is to show a step-by-step procedure for accessing data for an SQL 2000 Analysis server from Microsoft Excel. Data access can also be accomplished by VB, Visual Studio .NET 2003 IDE, and by running Multidimensional Expressions (MDX) queries against an Analysis server. Before getting into the nuts and bolts of this a few clarifications are in order as to the location and origin of the data.
Analysis Server Data
The Database
The data to be accessed is stored in the NewOlap database on the "Nechost" linked server. The "NewOlap" database data is derived from an OLTP datatbase, Northwind, on the SQL 2000 Server. The "Nechost" database and "Nechost" Analysis Server are on a Windows 2000 workstation.
Next: The Cube: MyFirstCube >>
More MS SQL Server Articles
More By Jayaram Krishnaswamy
