THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Analysis Services   (RSS)
Showing page 14 of 14 (134 total posts)
  • Analysis Services 2005 Performance Guide

    This is the paper we waited for a long long time: the Analysis Services 2005 Performance Guide is available for download from MSDN downloads. This paper is 120 pages of really precious informations. I don't have time to read all now, but I have found that Appendix C mention the Aggregation Utility, that should be included in AS2005 SP2 samples ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 31, 2007
  • Slow HTTP access to AS2000 with Win2K3 RTM without SP1

    Thanks to Microsoft support for Analysis Services (one of my customers opened an incident), I just discovered an issue that is not indexed anywhere in Google, so I write a post hoping to save time of the next unlucky user... I you use HTTP access to Analysis Services 2000 and you have Analysis Services installed on Windows 2003 Server RTM, there ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on January 29, 2007
  • 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
  • Analysis Services 2005: many-to-many dimension, killer feature!

    SQL Server 2005 has a new version of Analysis Services with a lot of new features, so much that a whole (thick) book would be necessary to describe everything. Nevertheless, many improvements are ''marginal'', in the sense that bring us better productivity (= less development time) or better performance. Aside administrative and development ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 4, 2004
Privacy Statement