blogs.conchango.com

One of the key goals of Analysis Services 2005 is to “bring together the best of both relational and OLAP reporting into a single Unified Dimensional Model”.  This is a very ambitious goal and most would agree that it would be difficult to fully achieve.  However, Analysis Services 2005 certainly does take huge strides in ...

The new aggregation functions provided out-of-the-box with Analysis Services 2005 are fairly well publicised, but I feel they still warrant a blog post. Analysis Services 2000 only had Sum, Count, Min, Max and DistinctCount.  Analysis Services 2005 also has the following.None results in no default aggregation.  This is presumably ...

A problem with the DistinctCount aggregate function for measures in Analysis Services 2000 is that it will not aggregate at leaf level if filtering only on a subset of the members in a level (or attribute).  A customer or ours is all too familiar with this limitation.  One of the enhancements to MDX in Analysis Services 2005 is that we ...

I once wrote an add-on for the SQL Server Accelerator for Business Intelligence to provide unknown-member functionality.  I was therefore naturally interested when I heard that it comes out-of-the-box with Analysis Services 2005. The idea with the unknown member is that, for each level of a hierarchy (or for each attribute in Analysis ...