THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » MDX » analysis servic... » PivotTable   (RSS)
  • Display the MDX query of an Excel 2007 PivotTable

    Often end users use Excel to navigate into the cube. Then they may ask you to produce a report using the same data. It would be useful to get the MDX query used by Excel. Moreover, Excel 2007 offers a good MDX quality of the produced query against Analysis Services 2005 (much better than Excel 2003). I don't know why Excel doesn't have such a ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 18, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement