Our app has an OLAP aspect within an OLTP app. The schema is a standard star schema.
For many things we use custom SQL to get subqueries for the aggregates. For data management we use AR.
Michael
Keep up to date with Rails on Twitter and This Week in Rails
Policies: Conduct, License, Maintenance, Security, Trademarks