ActiveWarehouse
The ActiveWarehouse library provides classes and functions which help with building Data Warehouses using Rails. It can be installed either as a plugin or as a Gem. If you install it as a gem you must include the following in your config/environment.rb:
require_gem 'activewarehouse'
require 'active_warehouse'
Additionally, to use the Rake tasks you must include the following in your Rakefile:
load 'tasks/active_warehouse_tasks.rake'
Generators
ActiveWarehouse comes with several generators
script/generate fact Sales
script/generate fact sales
Creates a SalesFact class and a sales_facts table.
script/generate dimension Region
script/generate dimension region
Creates a RegionDimension class and a region_dimension table.
script/generate cube RegionalSales
script/generate cube regional_sales
Creates a RegionalSalesCube class.
The rules for naming are as follows:
Facts:
Fact classes and tables follow the typical Rails rules: classes are singular and tables are pluralized.
Both the class and table name are suffixed by "_fact".
Dimensions:
Dimension classes and tables are both singular.
Both the class name and the table name are suffixed by "_dimension".
Cube:
Cube class is singular. If a cube table is created it will also be singular.