August 2005 - Posts

• The wonderful processing options of Analysis Services 2005

  Today I deeply tested processing options of Analysis Services 2005. A complete discussion of it is available on this paper by T. K. Anand , so I will not describe what is already well written but I'd like to share my today experience. What is more interesting Read More... Posted Tuesday, August 23, 2005 5:34 PM by Marco Russo (SQLBI) | 0 Comments

• Cascading many-to-many dimensions: it will work

  I'm waiting for the next CTP (September 05?) because it should work with cascading many-to-many dimensions. In a previous post I talked about the lack of functionality when you have more many-to-many dimensions chained together (I named this scenario Read More... Posted Monday, August 22, 2005 4:59 PM by Marco Russo (SQLBI) | 0 Comments

• Dimensional modeling with Analysis Services 2005

  First of all, a praise to Ralph Kimball : in the last days I read for the second time his The Data Warehouse Toolkit and this second read has been very inspiring to me. This time I've had the perspective of Analysis Services 2005 (SSAS) as OLAP target Read More... Posted Thursday, August 18, 2005 7:09 PM by Marco Russo (SQLBI) | 0 Comments

• VSTS and SSAS 2005: another example of bad design?

  Recently I've seen the multidimensional database that Visual Studio Team System use to produce statistics and reports about projects managed. There are several different cubes, each one with only one measure group, and many cubes use several dimensions Read More... Posted Wednesday, August 17, 2005 6:23 PM by Marco Russo (SQLBI) | 0 Comments