MDX with Microsoft SQL Server 2016 Analysis Services Cookbook - Third Edition

Tomislav Piasevoli, Sherry Li



Over 70 practical recipes to analyze multi-dimensional data in SQL Server 2016 Analysis Services cubes

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.

Table of Contents

1: ELEMENTARY MDX TECHNIQUES
2: WORKING WITH SETS
3: WORKING WITH TIME
4: CONCISE REPORTING
5: NAVIGATION
6: MDX FOR REPORTING
7: BUSINESS ANALYSES
8: WHEN MDX IS NOT ENOUGH
9: METADATA - DRIVEN CALCULATIONS
10: ON THE EDGE

PDF (conv) + EPUB + MOBI + AZW3: