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 |
|
Architect
Starting Member
8 Posts |
 Posted - 2008-03-07 : 14:47:33
|
| Suppose I have a dimensional data warehouse in a relational SQL Server2K5 database. What's the primary benefit of moving to SSAS? What does it buy me? My understanding is that when creating a SSAS cube, analysis services will slice and dice the data on all dimensions that fact is tied to, and calculate all the possible aggregates and intersections. Is that true? If so, is SSAS really only useful to support heavy ad-hoc reporting needs? Thanks,-a |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-03-07 : 22:47:07
|
| That's one thing AS does, it can do data mining too. You can use third party BI tools, but AS is free. |
 |
|
|
|
|
|
Why use Analysis Services?