Using Crosstab Summary Field without "Function"

Hello all of you,

I am working with BIRT since the last month to solve the cross-tab-problem of pentaho. Because of the good resident response-quality, I hope that one of you could help me with an, I think very unspectacular, issue:

I am using the Data Source to build a Data Cube in the eclipse BIRT designer. As dimensions, I've picked to tables, which are NOT directly connected with an foreign key. Let's name them 'pilot' and 'type'.

The third tables which is used as summary field is the table 'call' with it's attribut 'value'. This object ('call.value') has to be displayed in the cell of the crosstab, BUT WITHOUT ANY data-manipulation (e.g. the functions 'SUM',
'FIRST', etc. in the summary field). The only thing I want to achieve is the simple display of the summary field ('call.value') without any manipulation.

Is this possible and if yes: how?

Thank you in advance, I'm looking forward to any helping solution

Find more posts tagged with

Comments

mwilliams

Hi mgrohmann,

Is there only a single possible value for each slot in the matrix? If so, the function wouldn't matter. What issue are you having with the function in the crosstab?

mgrohmann

hey there,

thanks for your reply. Unfortunately, there are many values for each collumn. I am trying to draft the db-structure with it's relevant attributes:

table 'pilot'

|id|name|...|

table 'type'

|id|name|...|

table 'call'

The result should look like:

As you see, I just want the values to be passed through the BIRT-Data Cube to be diplayed in the shown cross tab.

Hope this helps, thanks again

mwilliams

mgrohmann,

So, there are many values per column, but only one value for each individual "pilot"/"type" combination. The function 'FIRST' would be the one that you should use to have no data manipulation. It just takes the first value that meets the row/column dimension criteria. Does this not work for you?

mgrohmann

it works absolutely perfect

thanks a lot for the explanation, now I have recognized what the "SUM" is used for. thanks again!

mwilliams

Excellent! Let us know if you have any other questions.

mgrohmann

Hey,

I would like to take the chance to post another question.

Although I made big steps forward manipulating data and reports, one thing won't work:

I've built a data cube where "time" is a dimension (group), but I have a time interval of 30 min (half an hour, but only the starttime). So I got values in the following format in my DB:

interval
______

10:00:00
10:30:00
11:00:00
11:30:00
...

I'm only able to use "hour" "second" "minute" as dimension-type, but BIRT strictly ignores the xx:30:00 values!
How can I setup my dimension as "30min-intervall" or how could I get BIRT showing every value?

mgrohmann

hey there,

the only working solution until now is to threat this field as "normal field", not as "date field".

mwilliams

mgrohmann,

Most likely this will be the way to do it. I don't think there'll be a way to do half hour increments with a date field.