Welcome to EMC Consulting Blogs

July 2006 - Posts

• Measure expressions: how performant are they?

  Oh, and before the anoraks out there mail me saying “did you know that ‘performant’ is not recognized as an adjective by the major dictionaries?”, yes I do know – but I like the word, so I’m using it! We are modeling Read More... Posted 25 July 2006 17:36 by christian.wade | 4 Comments Filed under: Analysis Services 2005, MDX, AS2005, SQL Server 2005, AS, Yukon, Measure Expressions, SQL Server, Analysis Services, SSAS

• Fact modelling and M2M dimensions in AS2005

  It is generally considered data warehousing best practice to split your facts into different tables if the granularity/dimensionality is different. This is a very common question in data warehouse design. Consider the following data model. The company Read More... Posted 25 July 2006 14:32 by christian.wade | 0 Comments Filed under: Analysis Services 2005, MDX, AS2005, SQL Server 2005, AS, Yukon, SQL Server, Analysis Services, SSAS, Dimensional Modelling, Dimensional Modeling

• AS 2005 Optimization Experiences

  I’m approaching the end of an enjoyable data warehousing project and we have collected some size/volume statistics around our Analysis Services 2005 cube. We have: * 48 Dimensions. This includes role-playing dimensions. * 751 Attributes and user Read More... Posted 12 July 2006 17:28 by christian.wade | 2 Comments Filed under: Analysis Services 2005, MDX, AS2005, SQL Server 2005, AS, Yukon, SQL Server, Analysis Services, SSAS, Dimensional Modelling, Dimensional Modeling