Practical Mdx Queries - 9780071713368

More than 300 ready-to-use, powerful MDX queries

Practical MDX Queries shows how to use Multi-Dimensional Expressions (MDX) to extract business intelligence from multi-dimensional cubes within Microsoft's Business Intelligence stack. The book’s approach is solutions-based and hands-on, containing more than 300 downloadable MDX queries that can be immediately applied across a wide variety of business intelligence-related problems. It begins with fundamental principles and simple queries and rapidly progresses to complex and sophisticated queries. The book is structured as follows:

• Query Overview: Introduction and description of query and its use
• Syntax: Complete syntax
• Result: Illustrates the data returned from the Analysis Services cube by the query
  
• Analysis: Analysis of the results and tips for customization

The book emphasizes MDX for use within Microsoft SQL Server Analysis Services (SSAS)—however, the techniques and queries can also be used across Excel, Excel Services in SharePoint, Reporting Services (SSRS), Integration Services (SSIS), Performance Point Server dashboards, Winforms and Webforms, and in a variety of third-party front-ends.

Practical MDX Queries covers
The Basics; Dimensions and Hierarchies; Slicing and Dicing; Sorting; KPIs; Empty Cells and Ranges; Calculations and Sets; Time Dimension; Time Dimension Calculations; Families and Navigation; Set Manipulation; Problems and Common Errors