Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
zaidqis
Yak Posting Veteran
63 Posts |
 Posted - 2006-06-13 : 04:55:43
|
| hiiwhat is SQL Server Analysis Services 2005 ??thank you |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2006-06-13 : 08:21:47
|
From BOOKS ONLINE:***************************************Microsoft SQL Server 2005 Analysis Services (SSAS) provides online analytical processing (OLAP) and data mining functionality for business intelligence solutions. Before designing a business intelligence solution using Analysis Services, you should familiarize yourself with the OLAP and data mining concepts required for a successful solution.Analysis Services combines the best aspects of traditional OLAP-based analysis and relational-based reporting by enabling developers to define a single data model, called a Unified Dimensional Model (UDM) over one or more physical data sources. All end user queries from OLAP, reporting, and custom BI applications access the data in the underlying data sources through the UDM, which provides a single business view of this relational data. Analysis Services provides a rich set of data mining algorithms to enable business users to mine their data looking for specific patterns and trends. These data mining algorithms can be used to analyze data through a UDM or directly from a physical data store. **********************************Basically what it is, is a place where you can aggregate data from your tables into a for where you can do very quick analysis of data by looking at it from all sorts of angles - The end result is manipulated with some kind of tool by High level company execs and Analysts.Duane.  |
 |
|
|
|
|
|
SQL Server Analysis Services 2005