As you're probably aware, strings rarely appear on facts, because they're not additive (can't be summed, averaged, etc.). The one exception I'm aware of is degenerate dimensions.
So, if "title" is a degenerate dimension in your schema, you shouldn't specify it as an aggregate. That, is you should probably remove "aggregate :title" from the fact. The problem with that is you would no longer have any aggregates. You can fix this by adding: aggregate :id, :type => :count Which will do a count on the ids in the fact table - basically a "Number of Projects" aggregate. In fact, the :type parameter is what you use to override strategy_name in general. It can be any SQL aggregate function (avg, max, or whatever else your db supports.) You can also add :distinct => true, if that's what you're looking for. _______________________________________________ Activewarehouse-discuss mailing list Activewarehouse-discuss@rubyforge.org http://rubyforge.org/mailman/listinfo/activewarehouse-discuss
