Calculating Quartiles in Analysis Services

Histogram with quartiles

Histogram with quartiles

In SQL Server Analysis Services 2008, there is a native Median function in MDX, but no native Quartile function. If you need to calculate quartiles, there are a few different ways to do this. You can either use native Excel functions, code the quartile algorithm in MDX or write the algorithm as an SSAS stored procedure in .NET. In this post, I cover each of these options and provide sample code for the MDX and stored procedure options.

Read more of this post

Uninstalling Visio Breaks Windows XP Backup

For a couple of months, I had been getting errors from our corporate backup application reporting that it was unable to backup all files. The problem had nothing to do with the backup client itself (Iron Mountain Connected Backup), but was actually a problem caused by uninstalling Microsoft Visio which broke Windows XP’s Volume Shadow Copy feature.

For anyone else experiencing a similar problem, I’ll document the issue. Back in March, I started getting notices that backup had failed and the backup client’s status box would list each problem with a message like the one below.

Read more of this post