300+ ready-to-use, powerful MDX queries
This hands-on guide shows you how to use Multi-Dimensional Expressions (MDX) to extract business intelligence from multi-dimensional cubes. Practical MDX Queries contains more than 300 downloadable MDX queries that can be applied across a wide variety of business intelligence-related problems. The use, syntax, and results of each query are described in detail. The book emphasizes MDX for use with SSAS within SSMS, but the techniques and queries also apply to SSRS, SSIS, MDX in SQL, MDX in DMX, MDX in XMLA, WinForms, WebForms, PerformancePoint Server, ProClarity, and many third-party applications.
Work with dimensions, hierarchies, levels, and members
Navigate both horizontally and vertically across dimensions and hierarchies
Sort the results of your queries
Access subsets of dimension members and measure values using the Where clause and Filter function
Use MDX query calculations
Extract and manipulate dates and times
Produce totals, subtotals, and changes cross time using aggregate and other functions
Create, visualize, and manipulate sets
Work with perspectives, subselects, and subcubes
Display and hide empty cells
Use, modify, format, and create Key Performance Indicators (KPIs)
Deliver MDX query results to end users
Art Tennick has worked in relational database design and SQL queries for over 20 years, and in MDX queries for 10 years. He has been involved in multi-dimensional database design, cubes, data mining, DMX, and MDX for 10 years. Recently, Art worked with several major retail and banking corporations to implement BI solutions using Microsoft SQL Server, SSAS, SSIS, SSRS, and Excel 2007/2010. His website is www.MrCube.net.
Keywords: PRACTICAL, MDX, QUERIES, ARTHUR TENNICK, BASICS, BOOK, GUIDE, HOW TO, DIMENSIONS, HIERARCHIES, SLICING, DICING, SORTING, KPIS, EMPTY, CELLS, RANGES, CALCULATIONS, BUSINESS INTELLIGENCE, BI, SETS, TIME, CALCULATIONS, FAMILIES, NAVIGATION, SET, MANIPULATION, PROBLEMS, COMMON, ERRORS, BUSINESS, INTELLIGENCE, GARTNER, DECISION-MAKING, EFFECTIVE, MULT-DIMENSIONAL EXPRESSIONS, LANGUAGE, EXTRACTION, CUBES, DATA, WAREHOUSES, DATABASE, VENDORS, MICROSOFT, SQL SERVER, ANALYSIS, SERVICES, SSAS, EXCEL, EXCEL SERVICES, SHAREPOINT, REPORTING SERVICES, SSRS, INTEGRATION SERVICES, SSIS, PERFORMANCE POINT SERVER, WINFORMS, WEBFORMS, KEY-PERFORMANCE INDICATORS, DEVELOPERS, REPORT DESIGNERS, DASHBOARD, POWER USERS, CORPORATE, BUSINESS INTELLIGENCE, BI, IBM COGNOS 8 BUSINESS INTELLIGENCE: THE OFFICIAL GUIDE, DATA WAREHOUSE DESIGN, ORACLE ESSBASE & ORACLE OLAP, STAR SCHEMA THE COMPLETE REFERENCE, PRACTICAL POWERPIVOT & DAX FORMULAS FOR EXCEL 2010, PRACTICAL SQL QUERIES FOR SQL SERVER 2008, PRACTICAL DMX QUERIES FOR MICROSOFT SQL SERVER ANALYSIS SERVICES 2008, CRYSTAL REPORTS 2008 THE COMPLETE REFERENCE, BUSINESSOBJECTS XI THE COMPLETE REFERENCE, DELIVERING BUSINESS INTELLIGENCE WITH MICROSOFT SQL SERVER 2008, MICROSOFT SQL SERVER 2008 REPORTING SERVICES, MICROSOFT SQL SERVER 2008 ANALYTICS & DATA VISUALIZATION, VISUALIZING INFORMATION WITH MICROSOFT OFFICE VISIO 2007, MICROSOFT OFFICE 2007 BUSINESS INTELLIGENCE 0071494243, BUSINESS INTELLIGENCE WITH MICROSOFT OFFICE PERFORMANCEPOINT SERVER 2007, SUCCESSFUL BUSINESS INTELLIGENCE, SAP BUSINESS INFORMATION WAREHOUSE REPORTING, CRCP CRYSTAL REPORTS CERTIFIED PROFESSIONAL ALL-IN-ONE EXAM GUIDE, ORACLE CRM ON DEMAND REPORTING, ORACLE DISCOVERER 10G HANDBOOK, APPLIED SAP BI 7.0 WEB REPORTS, THE POWER TO PREDICT, RESHAPING YOUR BUSINESS WITH WEB 2.0, CRM AT THE SPEED OF LIGHT, EVENT PROCESSING, SQL DEMYSTIFIED, SQL A BEGINNER'S GUIDE, SQL THE COMPLETE REFERENCE, ORACLE DATABASE 11G SQL