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 ...