May 15, 2007 at 10:11 am
Hello guys,
I have to build lots of reports on OLAP SQL Server 2005 Analysis services or, I am not sure yet, directly to DW on SQL Server 2005.
Any advantage and disvantage?
Based on your experience SSRS 2005 is a good tool for this goal or it is better another tool like business objects XI R2.
Thank,
any help will be very appreciated.
May 15, 2007 at 5:05 pm
We've tried using Crystal Reports (v9 - v11) and had no end of problems with it (though we haven't tried Business Objects). SSRS has proven to be much more logical, more transparent (Crystal hides a lot of what it's doing, but with SSRS you can see the report definition in XML) and a lot more reliable.
I'd suggest going against Analysis Services where possible. You may find MDX queries a bit daunting and confusing, but the reward is much faster reports.
May 16, 2007 at 2:43 am
Hello,
about your reply I read that SSRS 2005 use MDX to make report?
Or is it possible to access OLAP or DW using drag and drop objects to make reporting easier?
Thank
May 16, 2007 at 11:24 pm
There is a query builder in SSRS 2005 which makes things a lot easier. As long as you don't need anything too technical, you can get by without MDX. The query builder in SSAS2000 was quite poor.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply