MDX With Microsoft SQL Server 2008 R2 Analysis Services : Cookbook: 80 Recipes for Enriching Your Business Intelligence Solution With High-performance Mdx Calculations and Flexible Mdx Queries - Softcover

Piasevoli, Tomislav

Softcover

ISBN 10: 1849681309 ISBN 13: 9781849681308

Verlag: Packt Pub Ltd, 2011

Inhaltsangabe

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.

Über diesen Titel

Reseña del editor

This book offers practical, task-based, and immediately usable recipes covering a wide range of MDX calculations and queries. In addition to its cookbook style, which ensures the solutions are presented in a clear step-by-step manner, the explanations are done in great detail, which makes it good learning material for everyone who has experience in MDX and wants to improve. The book is designed in such a way that you can read it chapter by chapter or refer to recipes in no particular order. However, some of the recipes depend on each another. When this is the case, you will be notified. The book is focused on Microsoft SQL Server 2008 R2 Analysis Services, but most of the concepts and explanation are also applicable to previous versions of Microsoft SQL Server Analysis Services. If you are a Microsoft SQL Server Analysis Services developer and want to improve your solutions using MDX, then this book is for you. The book assumes you have a working knowledge of MDX and a basic understanding of dimensional modeling and cube design.

Biografía del autor

Tomislav Piasevoli is a Business Intelligence Specialist with years of experience with SQL Server Analysis Services. He lives in Croatia and works for SoftPro Tetral d.o.o. (http://www.softpro.hr), a company with a long tradition in building advanced SSAS frontends and implementing BI solutions on the Microsoft platform. During his career in the company, Tomislav has successfully implemented more than 20 still-in-use BI solutions and now specializes in dimensional modeling, cube design and MDX. Tomislav has been honored with Microsoft's MVP award twice, mostly for his contribution to the SSAS community on the MSDN forum. Besides solving MDX puzzles, he presents at conferences, writes articles for magazines, and maintains his blog at http://tomislav.piasevoli.com.

Details zur Ausgabe

• Verlag: Packt Pub Ltd
• Erscheinungsdatum: 2011
• ISBN 10: 1849681309
• ISBN 13: 9781849681308
• Einband: Tapa blanda
• Sprache: Englisch
• Anzahl der Seiten: 459
• Kontakt zum Hersteller: Nicht verfügbar