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.
The Software Quality Report (SQR) were build for version 1.2 of the Pentaho BI Platform.
In this document is the list of changes and fixes for the Penatho BI Platform 3.x from version 1.2 of the Pentaho BI Platform.
Pre-Requirements
Kettle (Data Integration / ETL) can be downloaded at: http://sourceforge.net/project/showfiles.php?group_id=140317&package_id=186321
This post will tell you how we have used Pentaho and SQR to create formated reports and graphs in ALM suite...
