Christopher Richard - Is the faculty for this training MDX - Multi Dimension eXpression MDX is a Key to all advanced functionality in Analysis Server JimRoy Number -- ? Books To Read to get to know more in detail about OLAPDM - 1) Datawarehouse Toolkit, A complete guide for DM - Ralf Kimble, Willy Pubs 2) MDX - MDX Solutions for SQL2005 and HyperonSpace - George Spafford, Willy pubs Difinitions in OLAP Slice - Members of one dimension Dice - Members of more than one dimension display A Cube can have upto 128 DimensionsMDX can have upto 64 Axes While fetching the Level name can't preccede the member name MDX Query Example 1) select {[Measures].[Order Quantity], [Measures].[Sales Revenue]} on columns, {[product].[categories].[bikes]} on rows from [quick start sales view] Result: OrderQuantity Sales Revenue Bikes 90268 94651172.7047148 2) select {[Measures].[Order Quantity], [Measures].[Sales Revenue]} on columns, {([product].[categories].[bikes]),([product].[categories].[clot...