web2py for (R)OLAP (pivoting)?

[Jurgis Pralgauskis]

Hi, 

OLAP Cube  model is based on dimensions (what to group by) and metrics (what to aggregate). 

Dimensions are mostly categorical data -- so can be nearly any fields (mostly FK).

Metrics would be aggregations of number fields. -- But [how] could they be described (incorporated into data model)?

Does pydal support aggregate expressions (that would be grouped by  dimensions chosen in form)?

[Val K]

Hi !, you can pass sql expressions to select() :
.select(db.tbl.field, 'SUM(sometbl.somefield) OVER(PARTITION BY sometbl.anotherfield) AS mysum )')