<p><b>More than 300 ready-to-use, powerful MDX queries</b><p><i>Practical MDX Queries</i> shows how to use Multi-Dimensional Expressions (MDX) to extract business intelligence from multi-dimensional cubes within Microsoft's Business Intelligence stack. The book&#8217;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:<ul><li><b>Query Overview:</b> Introduction and description of query and its use<li><b>Syntax:</b> Complete syntax<li><b>Result:</b> Illustrates the data returned from the Analysis Services cube by the query<br><li><b>Analysis:</b> Analysis of the results and tips for customization</ul><p>The book emphasizes MDX for use within Microsoft SQL Server Analysis Services (SSAS)&#8212;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.<p><b><i>Practical MDX Queries</i> covers</b><br> 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