[Mondrian] Aggregate functions

[Julian Hyde]

The 'last' function you propose sounds like a reasonable way to implement
semi-additive measures, if Mondrian supported it, but there are other ways
to achieve them.
 
Check out 'Semi-additive measures' under
<http://wiki.pentaho.com/display/analysis/FAQs>
http://wiki.pentaho.com/display/analysis/FAQs. Let me know whether that
solves your problem.
Julian


  _____  

From: mondrian-bounces at pentaho.org [mailto:mondrian-bounces at pentaho.org] On
Behalf Of Sebastián Beca
Sent: Thursday, October 08, 2009 12:13 PM
To: mondrian at pentaho.org
Subject: [Mondrian] Aggregate functions


Hello,

My company implements BI solutions based on Pentaho and Mondrian. On of the
biggest problems for our clients has been working with stock data, and
wanting to aggregate it along a Product dimension with SUM and along a Time
dimension with LAST. And the problem is that as far as we understand it is
not possible to use different aggregate functions along different dimensions
for a same measurement. The other problem is that the "last" function does
not exist.

My question is if there is any workaround to implement this kind of view in
Mondrian? Or are there plans to develop this functionality?

We have a team of developers here, could we possibly tackle the development
of this functionality or help out in any way? What would we need to know to
go at it?

Regards,

Sebastian.

-- 
Sebastián Beca C.
Gerente de Proyectos
sbeca at cognus.cl

Cognus, Top Line Consulting
Av. Presidente Riesco 5335 piso 9
Las Condes, Santiago, Chile
Tel: (562) 714 38 11
www.cognus.cl


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20091008/c4d13fc3/attachment.html