Re: Drill-downs and OLAP type data

Mondrian (which is a part of Pentaho BI stack) is an open source OLAP engine
with MDX.
See http://community.pentaho.com/projects/bi_platform/

2011/10/12 Anthony Presley <anthony(at)resolution(dot)com>

> Hi there!
>
> We have a typical data-warehouse type application, and we'd like to set up
> a star-schema type data analysis software product (which we'll be
> programming), on top of PG. The goal is to do fast roll-up, drill-down, and
> drill-through of objects / tables like locations, inventory items, and sales
> volume.
>
> After a few weeks of searching around, we're running into dead-ends on the
> front-end, and the back-end. PG doesn't support OLAP / MDX .... and the GUI
> tools that do this, for the most part, require MDX / OLAP (SPSS and DB2, MS
> SQL Analytics, etc...).
>
> What's the PG route here? Are there some secrets / tips / tricks / contrib
> modules for handling this?
>
>
> --
> Anthony Presley
>