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)
 Learning the Multi-Dimensional piece of SSRS

Author  Topic 

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-09-02 : 11:04:51
I have been working with Reporting Services for about 5 years now but only over standard relational tables (mostly SQL Server, Oracle and AS/400) but would like to learn Analysis server and how to build a cube and report from it.

Does anyone here have suggestions for books and websites to get me started?

All hsuggestions are appreciated.


John

"The smoke monster is just the Others doing barbecue"

robvolk
Most Valuable Yak

15732 Posts

Posted - 2009-09-02 : 11:49:50
A co-worker recommended this:

http://www.databasejournal.com/features/mssql/article.php/10894_1495511_6/MDX-at-First-Glance-Introduction-to-SQL-Server-MDX-Essentials.htm

Warning: big ad to skip

I started on it a while back but didn't finish. It's a pretty good intro.

I'd also recommend SQL Server Analysis Services: Step by Step by Microsoft Press.
Go to Top of Page

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-09-02 : 15:16:20
Awsomeness, thanks!

I don't mind the books. Got my start in reporting services with Brian Larson's book and it got moving in the right direction quickly.


John

"The smoke monster is just the Others doing barbecue"
Go to Top of Page

savior faire
Posting Yak Master

194 Posts

Posted - 2009-09-06 : 10:03:51
I agree that Brian Larsen's texts are very good. I used to of them for my training. In fact, that series: "SQL Server 2005 Hands ON XXXXX" are excellent, in my opinion.

Talk sense to a fool and he calls you foolish.
Go to Top of Page

savior faire
Posting Yak Master

194 Posts

Posted - 2009-09-06 : 10:06:57
I have fiddled with using cubes/mdx to produce ssrs reports. Larsen covers this in his SSRS book. You can fool around with this for the most part by created a data source to an SSAS server/cube and using the query builder to create the mdx expressions using drag and drop. Then reviewing/studying what was produced.
I have found that this is how one can easily learn this stuff.

Talk sense to a fool and he calls you foolish.
Go to Top of Page

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-09-07 : 07:54:43
My big concern is creating and populating the cube. I a past life I had a 3rd party tool that used SQl/Server but their tool was used to populate the cube from a DB2/400 database so I know the concepts just not the mechanics.

Thx,

John

"The smoke monster is just the Others doing barbecue"
Go to Top of Page
   

- Advertisement -