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 » MDX » stored procedure   (RSS)
  • Drillthrough on calculated measures

    Drillthrough is a great feature of Analysis Services, but it has a limitation – only cells without calculations covering them can be drilled through. This automatically rules out drillthrough for calculated members in general and calculated measures in particular. This limitation has been a subject to much debate in forums and blogs. It has been ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on September 2, 2008
  • Counting distinct values in MDX

    How many elements in the set have distinct values ? This sounds like a simple question. Apparently, this is well known problem in Excel, and there is a classic solution for it. There are plenty of sites in Internet (for example here and here) which give the following solution: =SUM(1/COUNTIF(A1:A6,A1:A6))) (note that this formula needs to be ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on June 14, 2008
  • Best practices for server ADOMD.NET stored procedures

    In this article we will discuss some of the best practices around writing efficient Analysis Services stored procedures using server ADOMD.NET. These days there is plenty of information about writing efficient MDX - in books, whitepapers, blogs, forums etc. Just recently Microsoft released two documents - Performance Guide and Design Best ...
    Posted to Microsoft OLAP by Mosha Pasumansky (Weblog) by mosha on April 19, 2007
Privacy Statement