How to quickly generate MDX Query by using SQL Profiler Or OLAP Pivot Table Extension

MDX queries are written to query SSAS Cubes. In this video we will learn now to generate MDX quickly by using SQL Server Profiler to generate MDX Query that we can use for our reports. We will also learn how to generate MDX query by using OLAP Pivot Table Extension. Once the query is generated, we can use this query in SQL Server Reporting Services to generate reports from Cube or use in other applications.