MDX with SSAS 2012 Cookbook

Key Features

• A wide range of time-related, context-aware, and business-related calculations
• Combine MDX with utility dimensions
• Illustration of techniques to enrich business intelligence solutions, aided by practical, hands-on Cookbook recipes

Book Description

What you will learn

• Create time-aware calculations that are relative to the current date
• Construct context-aware calculations that are relative to members on axes
• Implement business-related calculations such as forecasting, allocation of values, and ABC analysis
• Combine MDX with utility dimensions
• Implement error handling
• Apply AND, OR, NOT logic
• Conditionally format your MDX calculations
• Optimize, dissect, and debug MDX calculations and queries
• Capture MDX generated by SSAS front-ends
• Register SSAS-related assemblies and use stored procedures in them

Who this book is for

This book is aimed towards developers. However people experienced with other BI and/or SSAS functions will be able to use this book. If you are a Microsoft SQL Server Analysis Services developer and want to improve your solutions using MDX, then this book is for you.

This book is also an essential resource for report developers who need to access the multidimensional cubes through the MDX language.

The book assumes you have some basic working knowledge of MDX and a basic understanding of dimensional modelling and cube design.