I'm working on a proof of concept using the active warehouse plugin. I have my dimension tables as
city_dimension (country_name, state_name, city_name) person_dimension (first_name, last_name, city_id) company_dimensoin (name, city_id) my facts are the projects that tie them together project_facts (:title, :city_id, :person_id, company_id) here is a cube that sorta works.... class CityPeopleCube < ActiveWarehouse::Cube reports_on :project pivots_on :city, :person end and my fact file... class ProjectFact < ActiveWarehouse::Fact aggregate :title dimension :date dimension :city dimension :person dimension :organization end of course, it tries to place a sum(project_facts.title) in the SQL query. I would rather not do that. I looked at the lib/active_warehouse/aggregate/aggregate.rb and ../aggregate_field.rb but I don't see a way to override the strategy_name = :sum. Well, I can do aggregrate :title, :type => :string but then my SQL query will crash when it wraps the project_facts.title with string. any ideas ?
_______________________________________________ Activewarehouse-discuss mailing list Activewarehouse-discuss@rubyforge.org http://rubyforge.org/mailman/listinfo/activewarehouse-discuss
