This book emphasizes MDX to be used with the SSAS in SSMS, but the technique and the question also applies to the SSR, SSIS, MDX in SQL, MDX at DMX, MDX in XMLA, WinForms, WebForms, PerformancePoint Server, ProClarity, and many third-party applications. Working with the dimensions, hierarchies, levels, and members of the Navigation both horizontally and vertically in all dimensions and hierarchies Sort the results of your queries access a subset of dimension members and measure values using the where clause and filter Use Extract MDX query function calculations and manipulate date and time to produce a total, subtotal, and cross-time changes using aggregate functions and other Create, visualize, and manipulate Working sets with perspective, subselects, and subcubes Display and hide empty cells Use, modify, format, and create a Key Performance Indicator (KPI ) Delivering MDX query results to end users