Using SSAS 2005/2008 as PowerPivot Data Source: Direct MDX
If you write direct MDX queries using SSAS 2005/2008 as a PowerPivot data source, it is better if you prepare your MDX query by using another editor. For example, write and test your MDX query by using SQL Server Management Studio and then copy & paste your query into the user interface provided by the Table Import Wizard. The remaining part of this post is dedicated to an explanation of the reasons for that.