Accessing OLAP using ASP.NET - How to install Analysis Services

(Page 3 of 4 )

How to install Analysis Services

1. Insert the SQL Server 2000 CD into the CD-ROM drive. This starts the SQL Server 2000 Setup program. If the Setup program does not start automatically, run the Autorun.exe program in the root directory of the CD-ROM.
   
2. Click Install SQL Server 2000 Components.
   
3. Click Analysis Services to start the Analysis Services Setup program.
   
4. In the Welcome step, click Next.
   
5. Proceed by selecting your own options to complete the installation.

Open and View OLAP Information/Data

“Foodmart 2000” is a sample OLAP database created by SQL Server 2000 Analysis Services during installation. The following are the steps to view that OLAP (database) information:

• Open Start -> Programs -> Microsoft SQL Server -> Analysis Services -> Analysis Manager.
• Open Analysis Servers -> <Server Name> -> Foodmart 2000 -> Cubes ->and select Sales (as shown in the following)

• On the right hand side pane, click on Data tab and you should be able to see something like the following:

• You play by dragging and dropping the combo boxes (dimensions) either on to columns or rows on the grid and observe the measures.
 

Next: Creating a .NET Web Application to Access OLAP >>
 

More MS SQL Server Articles
More By Jagadish Chaterjee

Comments On: Accessing OLAP using ASP.NET

>>> Be the FIRST to comment on this article!