Sum Distinct Aggreration in a multi-dimensional model

Jul 30, 2009

I am working with a multi-dimensional star-schema

http://en.wikipedia.org/wiki/Star_schema

and I need a special aggregation function to sum without duplicates

see http://forums.pentaho.org/showthread.php?t=71116

I can see how this is done with SQL but not sure what is the best approch to implement it with Mondrian.

UPDATE: I was able to create the measure with relativly simle MDX. Code is attached.