ActiveWarehouse 0.3.0 is now available as a Gem, Zip or Gzip file from RubyForge. You may also install directly from the subversion repository, as always. ActiveWarehouse is an open source plugin for Rails that extends Rails to add support for data warehouse development. It has base classes for facts, dimensions, bridges and cubes as well as aggregation strategies, hierarchal dimensions, role-playing dimensions, etc. It includes generators for each of the base classes and their migrations and unit test stubs. It''s been a while (3 months to be exact) since I''ve done a proper ActiveWarehouse release, however development has been progressing on all parts of the framework. The cube implementation has been completely redesigned to support pluggable aggregation. Aggregation has been refactored as well to support aggregation across more than just two dimensions. Currently there is support for a direct query aggregate (i.e. non-persistent) and a ROLAP aggregate. We are currently working on other aggregation methods for future releases. Facts now define their dimensions using the dimension directive which has behavior that extends the belongs_to from ActiveRecord. 0.3.0 Changes include: * Updated docs. * Fixed bug in report helper so that dimension ordering override now works as expected. * Changed dimension migration generator template to remove all the extraneous code. * Complete overhaul of the Cube class implementation. * Cube query results now encapsulated in the CubeQueryResult class. * Cube query method now takes two forms, either the old style form with 4 required arguments and 5 optional arguments (with the last argument an options Hash) or the new style which takes a single Hash of options. * Completely rewrote aggregation system. Cubes now delegate aggregation to Aggregation implementation classes. * Developed NoAggregate aggregation strategy that goes directly to the fact and dimension tables. * Refactored render_report helper. * Refactored bridge class to allow for extension for specific bridge types (such as hierarchical bridges or weighted grouping bridges). * Aggregate fields are now defined with classes. The base class is the Field class and it is implemented by AggregateField and CalculatedField. * Added support for prejoining a fact with some or all of its dimensions * Dimension to fact relationships are now defined with the dimension directive in the Fact class. This directive delegates to belongs_to. * PosRetailSalesTransactionCube would now default to using PosRetailSalesTransactionFact and all of its dimensions as its report_on and pivots_on configuration by default. This means you only need to create a cube class and then can define report_on or pivots_on if you need to override these defaults. * Updated dimension view support, used for dimension role-playing. * DateDimension is now implemented as a class extending from Dimension. * Test cases modified to reflect ETL changes as well as new functionality. Documentation is available at http://activewarehouse.rubyforge.org/rdoc/ . Enjoy! -- Cell: 808 782-5046 Current Location: Melbourne, FL --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---