THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » SSAS » M2M   (RSS)
  • The Many-to-Many Revolution 2.0 #ssas #mdx #dax #m2m

    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 ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on November 9, 2011
  • CREATE GLOBAL CUBE statement does not support cascading M2M relationships?

    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 ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on July 1, 2008
  • Analysis Services 2005: many-to-many dimension, killer feature!

    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 ...
    Posted to SQLBI - Marco Russo (Weblog) by sqlbi on October 4, 2004
Privacy Statement