Hi all, I'm brand new (as in, this morning) to AW and OLAP, and have come up against a wall pretty quick. I'm working on a newspaper site, where an Article has_many :regions and has_many :topics. I see from pages like http://www.dbmsmag.com/9808d05.html and http://technet.microsoft.com/en-us/library/ms345139.aspx that the star schema can be extended with bridges/helpers/snowflakery to support multivalued dimensions, but I have questions: 1. A couple of places seemed to argue that the bridge tables defeated the performance advantages of the star schema, as bridge tables would have even more rows than fact tables. Agree/disagree? 2. I suppose I could just make three fact tables, Article, ArticleRegion, and ArticleTopic, but that's a bunch of added complexity, and I lose the ability to slice by both topic and region at once (or by topic grouping, without double-counting). Agree/disagree?
And most importantly: 3. How would I implement such a beast in ActiveWarehouse? I got as far as `script/generate bridge`. :P Is there cube support for this type of thing? Thanks, Devin _______________________________________________ Activewarehouse-discuss mailing list Activewarehouse-discuss@rubyforge.org http://rubyforge.org/mailman/listinfo/activewarehouse-discuss