All Tags »
MDX »
stored procedure (RSS)
Sorry, but there are no more tags available to filter with.

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 ...

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 ...