Data Cube : Change mesure condition of one dimension

dx_cal

<p>Hi, </p><p> </p><p>Before posting this new topic, I've done a lot research on the forum BirtExchange and Eclipse Community Forum, but I haven't found a solution to my problem.</p><p> </p><p>I'm using Birt Designe to make reports based on the database of JIRA.</p><p> </p><p>I met a problem while I'm trying to make a cross table. </p><p> </p><p>The data set I gets is something like this: </p><p>Issue ID - Issue type - Open Date - Close Date</p><p>12131   - Incident      - 01/03/2013 - 21/04/2013</p><p>12132   - Service Request - 23/03/2013 - 01/04/2013</p><p>12133   - Service Request - 01/02/2013 - 01/05/2013</p><p> </p><p>And I would like to make a cross table (Data Cube) like:</p><p>(Picture 2)</p><p> </p><p>Number of open and rest issues contains deux types of issue: </p><p>1. Issues which are opened in this week ( controled by the "Open Date") </p><p>2. Issues which are opened before this week and are closed after the start of the week (Controled by the "Close Date")</p><p> </p><p>The problem is that in the data cube I can't combine the 2 dimensions of date.</p><p> </p><p>Could someone give me a resolution? Maybe I should do some script? How? </p><p> </p><p>Thanks.</p><p> </p><p>Xi</p>

kclark

<p>Can you provide some sample data maybe in xml or csv format so I can work on an example?</p>