|
Re: Aggregations in crosstabs [message #668687 is a reply to message #668578] |
Fri, 06 May 2011 17:52 |
|
Marco,
You should be able to put the aggregates in the cube itself. If you
could put together a csv file I could build an example off of it. I
have posted examples of using the de-api to create a crosstab on birt
exchange, but it is probably better to first design it in the designer
and then use the api to recreate what you want.
Jason
On 5/6/2011 6:18 AM, Marco wrote:
> Hi,
>
> How can I specify how exactly the measures should be aggregated?
>
> Let's assume I have 3 dimensions:
> A ... date
> B ... organizational structure consisting of field country / city / site
> C ... shift
> And measures:
> X ... site cost
> Y ... accumulated number of units produced
> All from a scripted data set which delivers multiple lines per dimension
> combination.
>
> Now I want a crosstab between A and B. C is not relevant.
> X should be the sum of all shifts (C), the sum of each period (A), the
> average of each unit (B).
> Y should be the average of all shifts (C), the last of each period (A),
> the sum of each unit (B).
>
> Where would I specify these aggregations?
>
> What if I have more than 1 vertical dimension with different aggregation
> functions?
>
> And you would help me a lot if you could tell me what are the relevant
> elements in the source of a report design since I need to do this
> programmatically.
>
> Thanks a lot,
> Marco
|
|
|
|
Powered by
FUDForum. Page generated in 0.04548 seconds