MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook - Softcover

Piasevoli, Tomislav

Softcover

ISBN 10: 1849681309 ISBN 13: 9781849681308

Publisher: Packt Publishing, 2011

Synopsis

MDX-related books often dedicate a significant part of their content to explaining the concepts of multidimensional cubes, the MDX language and its functions, and other specifics related to working with Analysis Services. And that's perfectly fine, there should be books like that, the tutorials that teach the concepts. However, that also means that when it comes to examples, there's usually not enough space to provide all the details about them and their variations, otherwise the book would become huge or oftentimes lose its focus. The result of that is that making a step further from the provided calculations and queries might not be an easy task for an average reader. The other problem with tutorials is that the solution to a particular problem might be scattered throughout the book, which is where the cookbook style of books like this one come into play. Similar to data warehouses where we consolidate many tables of the relational database into a few and then organize those dimension tables in a topic-based star schema, in cookbooks we aggregate the information about a particular problem in form of one or more recipes and present that topic-based knowledge in full detail. Both the relational databases and the data warehouses have their purpose; it's not uncommon to see them together in one place. The same is true about books and their approaches. What we also know is that there are far too few data warehouses than relational databases. Again, the same is with MDX-related cookbooks in respect to MDX tutorials, particularly those dealing with advanced topics. As a writer, I hope you recognize my intention and the value this book could bring you. As a reader, we rarely have enough time to start reading a book, not to mention f nish it. This is another advantage of the cookbook format. You can browse through the contents and look for the solution to a particular problem. As the recipes are relatively short and organized in chapters, that task won't take much of your time. All the information will be in one place. In addition to that, you'll see which recipes are related to that one, so that you can learn even more.

About this title

About the Author

Tomislav Piasevoli
Tomislav Piasevoli is a Business Intelligence Specialist with years of experience with SQL Server Analysis Services. He lives in Croatia where he has successfully implemented many still-in-use BI solutions and now specializes in dimensional modeling, cube design and MDX consulting worldwide. Tomislav has been honored with the Microsoft's MVP award three times for his contribution to the SSAS community. Besides solving MDX, cube design and dimensional modeling puzzles, he presents at conferences, writes articles for magazines, and maintains his blog at tomislav.piasevoli.com.

Edition details

• Publisher: Packt Publishing
• Publication date: 2011
• Language: English
• ISBN 10: 1849681309
• ISBN 13: 9781849681308
• Binding: Paperback
• Number of pages: 480