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 |
|
MorrisK
Yak Posting Veteran
83 Posts |
 Posted - 2008-07-09 : 09:38:15
|
| I'm new to Analysis Services and I've been looking into using it for some reports. I was wondering something and was hoping someone could clarify.First off, I'm still on SQL Server 2000. What I'm wondering is this - Even if you can integrate Analysis Services into a Reporting Services report you still aren't taking advantage of the strength of Analysis Services, correct?What I mean is it seems the benefit of Analysis Services appears to be it's ability to enhance performance by pre-aggregating. However, if you are pulling data into a Reporting Services report (matrix for example) the report is still having to "re-do" the aggregations isn't it?I'm looking at the sample report that came with SQL 2000 - Foodmart Sales. Also, I'm reading http://msdn.microsoft.com/en-us/library/aa902647.aspxI hope all this explains my question. It seems that if I'm right, it would be easier to just use a T-SQL query or stored procedure to pull the data and not have to learn MDX or manage Analysis Services.Thanks in advance,Kevin |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-09 : 22:11:19
|
| Why? You can build report from cubes directly. |
 |
|
|
|
|
|
Analysis Services provides no benefit with SSRS?