SQL Server Analysis Services Concepts
page 4 of 6
by Nidal Arabi
Average Rating: This article has not yet been rated.
Views (Total / Last 10 Days): 27640/ 58

Where Does SSAS Fit in Microsoft SQL Server

If you take a look of the picture downloaded from the Microsoft Technet website, you can see that SSAS is only a part of a group.

Figure 1: MS SQL Server Components (High Level)

If you are going to develop a business intelligence solution, you will definitely use two if not three of these components.

The Analysis Services component is an essential one (the subject of talk). The second is the core of MS SQL which is Integration Services. In order to feed AS with data, you need the IS (integration services) to transfer data from any input source (like an SQL Database, Oracle Database, Text Files, etc.) into the AS database. The third component that is of interest to you would be Reporting Services to deliver your OLAP cubes in a presentable way to your end user, but you could use Microsoft Office, SharePoint or even any third part tool.

You could also use notification services to tell you the status of jobs (Data Import, Cube Generation, etc.).

View Entire Article

User Comments

Title: bbb   
Name: bbb
Date: 2012-05-10 6:48:04 AM
Yes Good
Title: aaa   
Name: aaa
Date: 2008-09-26 12:32:09 AM
Yea Good

Community Advice: ASP | SQL | XML | Regular Expressions | Windows

©Copyright 1998-2021 ASPAlliance.com  |  Page Processed at 2021-12-02 11:37:42 PM  AspAlliance Recent Articles RSS Feed
About ASPAlliance | Newsgroups | Advertise | Authors | Email Lists | Feedback | Link To Us | Privacy | Search