Synopses & Reviews
Synopsis
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.
Synopsis
Over 70 practical recipes to analyze multi-dimensional data in SQL Server 2016 Analysis Services cubes
Key Features
- Updated for SQL Server 2016, this book helps you take advantage of the new MDX commands and the new features introduced in SSAS
- Perform time-related, context-aware, and business related-calculations with ease to enrich your Business Intelligence solutions
- Collection of techniques to write flexible and high performing MDX queries in SSAS with carefully structured examples
Book Description
If you're often faced with MDX challenges, this is a book for you. It will teach you how to solve various real-world business requirements using MDX queries and calculations.
Examples in the book introduce an idea or a problem and then guide you through the process of implementing the solution in a step-by-step manner, inform you about the best practices and offer a deep knowledge in terms of how the solution works. Recipes are organized by chapters, each covering a single topic. They start slowly and logically progress to more advanced techniques.
In case of complexity, things are broken down. Instead of one, there are series of recipes built one on top of another. This way you are able to see intermediate results and debug potential errors faster.
Finally, the cookbook format is here to help you quickly identify the topic of interest and in it a wide range of practical solutions, that is - MDX recipes for your success.
What you will learn
- Grasp the fundamental MDX concepts, features, and techniques
- Work with sets
- Work with Time dimension and create time-aware calculations
- Make analytical reports compact, concise, and efficient
- Navigate cubes
- Master MDX for reporting with Reporting Services (new)
- Perform business analytics
- Design efficient cubes and efficient MDX queries
- Create metadata-driven calculations (new)
- Capture MDX queries and many other techniques