Archive: April 2008

  • Semi Additive Measures using SQL Server Standard

    One of the most frustrating limitations of SQL Server 2005 Standard edition is that it doesn’t support semi additive measures in SSAS Analysis Services cubes. This post explains a work around that provides similar functionality without having to shell out for the Enterprise Edition. What Are Semi Additive Measures? Semi Additive measures are values that you can summarise across any related dimension except time. For example, Sales and…

    » Read more
  • Aramark Contract Won

    Purple Frog have won a repeat contract with Aramark to design and supply a BI project for their newly won contract with NAAFI.

    » Read more