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)
Sorry, but there are no more tags available to filter with.
  • 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
Privacy Statement