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.

 All Forums
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 Why use Analysis Services?

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.
Go to Top of Page
   

- Advertisement -