Practical MDX Queries: For Microsoft SQL Server Analysis Services 2008
, by Tennick, ArtNote: Supplemental materials are not guaranteed with Rental or Used book purchases.
- ISBN: 9780071713368 | 0071713360
- Cover: Paperback
- Copyright: 6/14/2010
More than 300 ready-to-use, powerful MDX queriesPractical MDX Queriesshows 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 customizationThe 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 Queriescovers 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