In September 2006 I had announced in this blog the release of the first version of The Many-to-Many Revolution, a whitepaper that describes how to leverage the many-to-many dimension relationships feature that had being available since Analysis Services 2005. The paper contains many generic patterns that can be applied in many common data ...

Thanks to a comment sent by a reader of my M2M paper, I just found a possible bug (or ''not supported by design feature'') of the CREATE LOCAL CUBE mdx statement. In short, it seems that a simple many-to-many dimension relationship is supported, but if you have a cube with multiple many-to-many dimension relationships chained together, this ...

SQL Server 2005 has a new version of Analysis Services with a lot of new features, so much that a whole (thick) book would be necessary to describe everything. Nevertheless, many improvements are ''marginal'', in the sense that bring us better productivity (= less development time) or better performance. Aside administrative and development ...