Can you provide me the tutorial for SSAS 2008 which also includes learning MDX queries also ?
+2
A:
I would recommend starting with the books online tutorials for Analysis Services and the books online tutorials for MDX. You can't get much better help for free.
The Microsoft SQL Server 2008 MDX Step by Step is the best book I've read regarding learning MDX queries when you are just starting out. It was about as good as SQL Queries for Mere Mortals but for MDX.
The Microsoft SQL Server 2008 Step by Step is the best book I've read regarding learning how to build a cube from scratch. I went through building my first cube with the samples and then built a cube on my real company data following the same steps. This book won't help teach you MDX, though.
I also found the Microsoft Data Warehouse Toolkit useful from a conceptual level, but I didn't find it to be very useful from a practical level. The Applied Microsoft Analysis Services 2005 and Microsoft Business Intelligence Platform book was very useful for digging into the nuts and bolts at a level that exceeded the Step by Step books and it has a very good series of chapters on MDX programming that helped me move beyond the MDX Step by Step book.
Googling MDX tutorial will give you some basic queries, but I found I couldn't go beyond the basics without hitting the books. Good luck!
Registered User
2010-07-26 22:51:24
Thanks. I think I had got a lot.
Sreejesh Kumar
2010-07-27 05:31:29
I would not recommend "Microsoft SQL Server 2005 Anaylsis Services" by Melomed et al. Very dry and overwhelming levels of detail in earlier chapters. i.e. Describing DDL used inside various objects when really you need to get to grips with the fundamentals of what things are.
adolf garlic
2010-07-28 14:06:37
A:
I have previously offered my own careful explanation of how OLAP works and how to learn MDX, and they have been welcomed. http://sites.google.com/site/merlinmags/
Magnus Smith
2010-08-12 10:47:01