search

EndPointCorp / end-point-blog

End Point Dev blog
https://www.endpointdev.com/blog/
17 stars 65 forks source link

Comments for Subverting PostgreSQL Aggregates for Pentaho #171

Open phinjensen opened 7 years ago

phinjensen commented 7 years ago

Comments for https://www.endpointdev.com/blog/2009/07/subverting-postgresql-aggregates-for/ By Josh Tolley

To enter a comment:

  1. Log in to GitHub
  2. Leave a comment on this issue.
phinjensen commented 7 years ago 
original author: Jeff Davis
date: 2009-07-15T13:33:25-04:00

I like that PostgreSQL provides so many ways to work around problems and limitations in other parts of the system.

phinjensen commented 7 years ago 
original author: Josh
date: 2009-07-26T14:00:53-04:00

Josh,

Maybe we should think about fixing Mondrian instead to accept custom aggregates. They take patches ...

phinjensen commented 7 years ago 
original author: Joshua Tolley
date: 2009-07-26T16:37:55-04:00

They do take patches, and I've considered writing one to do just that. In fact I'm still considering it. For the application I need these aggregates for, time wouldn't have easily permitted figuring out the software, writing the patch, getting it accepted, and in particular getting it in a version supported by Pentaho. But the Mondrian community seems a friendly one, and I may still write one, if no one beats me to it.

phinjensen commented 7 years ago 
original author: Dan
date: 2013-01-14T04:10:04-05:00

This is a great post, thanks very much!

One thing though, the syntax is wrong. It should be MeasureExpression not KeyExpression in the mondrian xml.

http://mondrian.pentaho.com/documentation/schema.php#XML_MeasureExpression