<p>I have a data cube and I wish to summarize over string data types.</p>
<p>Until now, the only working functions for summary fields of type STRING I found are: MIN, MAX, FIRST, LAST.</p>
<p> </p>
<p>I wish to have a summary function like "concatenate all values using a given separator".</p>
<p>Is there any extension point where I can add such a summary-function?</p>
<p> </p>
<p>A long time ago, a guy gave me the hint to use a grouped table instead of a data cube and to add sub-reports in the table cells.</p>
<p>That works for "small" data sets - but on larger data sets the runtime increases to more than 5 minutes.</p>
<p>I believe this is because the sub-reports are joins of three data sets and it looks like BIRT joins these data sets again for each sub-report.</p>
<p> </p>
<p>Can anyone give me a hint?</p>
<p> </p>
<p>Thanks<br>
Widi</p>
