Welcome to EMC Consulting Blogs

April 2005 - Posts

• Online SQL Server 2005 VPCs

  As pointed out by Kimberly Tripp here , there are online SQL Server 2005 VPC labs available at http://msdn.demoservers.com/login.aspx?group=sql2005 . You just create a logon, install an ActiveX control and then start playing with SQL Server 2005! There Read More... Posted 13 April 2005 09:54 by christian.wade | 0 Comments

• UDM, New Dimension Types and Analysis Services 2005

  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 Read More... Posted 07 April 2005 16:21 by christian.wade | 4 Comments Filed under: Analysis Services 2005, MDX, AS2005, SQL Server 2005, AS, Yukon, SQL Server, Analysis Services, SSAS, Dimensional Modelling, Dimensional Modeling, UDM

• Semi-Additive Measures in Analysis Services 2005

  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 Read More... Posted 07 April 2005 16:06 by christian.wade | 3 Comments Filed under: Analysis Services 2005, MDX, AS2005, SQL Server 2005, AS, Yukon, SQL Server, Analysis Services, SSAS, UDM, Semi Additive Measures, Semi-Additive Measures

• Distinct Count in Analysis Services 2005

  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 Read More... Posted 03 April 2005 13:16 by christian.wade | 2 Comments Filed under: Analysis Services 2005, MDX, AS2005, SQL Server 2005, AS, Yukon, SQL Server, Analysis Services, SSAS, UDM, Distinct Count

• Unknown Member and Analysis Services 2005

  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 Read More... Posted 01 April 2005 17:59 by christian.wade | 8 Comments Filed under: Analysis Services 2005, MDX, AS2005, SQL Server 2005, AS, Yukon, SQL Server, Analysis Services, SSAS, Dimensional Modelling, Dimensional Modeling, UDM, Unknown Member

• I'm Back ...

  I’ve been a bit quiet (or entirely muted to be precise) on the blogging front lately. I should hopefully correct this soon. I did a workshop with a big customer who is looking to upgrade from AS2000 to AS2005 in the Beta3 timeframe. The demo alone Read More... Posted 01 April 2005 17:37 by christian.wade | 0 Comments