Sum Distinct Aggreration in a multi-dimensional model
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.