In a previous post we have installed the Pentaho server and used CDF code to create a dashboard.

In this post we will develop another dashboard for Bugzilla using CDE - the Dashboard Editor..

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.

In previous post we have developed a dashboard with CDE, the dashboard needs a parameterized and secured data access layer to provide the data for the graphs, selectors and texts on the screen while encapsulating the data access complexity - the CDA.

Once the dashboard is complete and users find valuable information or spot insightful patterns they would definitely want and ask you to provide data export functionality to the dashboard, which is easier done than said.

All you need is a Text Component with this expression:

Here is an good forward-looking review of MDM hot trends from Information Management.

כולם מדברים על הערך העיסקי והחזר ההשקעה מפתרון Master Data Management. מאמר זה מסביר במילים פשוטות מה זה MDM ואיך תדע אם הארגון שלך זקוק לו.

" If I had my way, everything would be released under the WTFPL "

http://www.codinghorror.com/blog/2007/04/pick-a-license-any-license.html

ZK is a quite impressive open source Ajax + Mobile framework.

The demo also looks nice.

http://zkoss.org/zkdemo/userguide/

Did you hear of it?