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.

 

Thank you for your interest!

We will contact you as soon as possible.

Send us a message

Oops, something went wrong
Please try again or contact us by email at info@tikalk.com