blogs.conchango.com

Browse by Tags

• Analysis Services
• Analysis Services 2005
• AS
• AS2005
• Dimensional Modelling
• MDX
• SQL Server
• SQL Server 2005
• UDM
• Unknown Member
• Yukon

• 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

• 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

• 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