Re: [GENERAL] Drill-downs and OLAP type data

2011-10-13 Thread Anthony Presley
Notes are below ... 2011/10/12 Ondrej Ivanič ondrej.iva...@gmail.com Hi, The *problem* with Greenplum is that it's ultra-expensive once you leave the CE version - and you're not supposed to be using the CE version for commercial usage last I read the license. Has that changed? Not

Re: [GENERAL] Drill-downs and OLAP type data

2011-10-12 Thread Ondrej Ivanič
Hi, On 12 October 2011 14:50, Anthony Presley anth...@resolution.com wrote: 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

Re: [GENERAL] Drill-downs and OLAP type data

2011-10-12 Thread Anthony Presley
2011/10/12 Ondrej Ivanič ondrej.iva...@gmail.com Hi, On 12 October 2011 14:50, Anthony Presley anth...@resolution.com wrote: 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

Re: [GENERAL] Drill-downs and OLAP type data

2011-10-12 Thread Anthony Presley
2011/10/12 Filip Rembiałkowski plk.zu...@gmail.com 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/ Thanks ... we're familiar with Mondrian. Unfortunately, the only stable GUI for it under $30k is

Re: [GENERAL] Drill-downs and OLAP type data

2011-10-12 Thread Ondrej Ivanič
Hi, The *problem* with Greenplum is that it's ultra-expensive once you leave the CE version - and you're not supposed to be using the CE version for commercial usage last I read the license.  Has that changed? Not sure. I haven't seen something like that in the license. After POC we bought HW

[GENERAL] Drill-downs and OLAP type data

2011-10-11 Thread Anthony Presley
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,

Re: [GENERAL] Drill-downs and OLAP type data

2011-10-11 Thread Craig Ringer
On 10/12/2011 11:50 AM, Anthony Presley wrote: What's the PG route here? Are there some secrets / tips / tricks / contrib modules for handling this? I don't see much discussion of DW, OLAP-type workloads here. Pg doesn't support index-oriented tables (though IIRC 9.2 will add covering

Re: [GENERAL] Drill-downs and OLAP type data

2011-10-11 Thread Filip Rembiałkowski
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 anth...@resolution.com Hi there! We have a typical data-warehouse type application, and we'd like to set up a star-schema