Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 353481

Summary:

Running sum for crosstab

Product:

z_Archived

Reporter:

Tomas Greif <greif.tomas>

Component:

BIRT

Assignee:

Birt-Data-inbox <Birt-Data-inbox>

Status:

NEW ---

QA Contact:

weiming tang <weiming.tang>

Severity:

enhancement

Priority:

CC:

bluesoldier, greif.tomas, weiming.tang

Version:

unspecified

Target Milestone:

---

Hardware:

OS:

Windows XP

Whiteboard:

Attachments:

Description	Flags
Running sum in crosstab - aggregation orientation and partitions	none

Description Tomas Greif

2011-08-01 05:00:54 EDT

Build Identifier: 

Add running sum function to crosstab. User should be able to set in desinger:
- whether rows or columns should be aggregated
- partition expression (e.g. to get cummulated PL report by years)

Reproducible: Always

Comment 1 Xiaoying Gu

2011-08-22 22:17:40 EDT

(In reply to comment #0)
> Build Identifier: 
> 
> Add running sum function to crosstab. User should be able to set in desinger:
> - whether rows or columns should be aggregated
> - partition expression (e.g. to get cummulated PL report by years)
> 
> Reproducible: Always

We already have running sum function in crosstab. But as to the two requirements, I don't quite understand. Can you give an example to show the case ? Thanks.

Comment 2 Tomas Greif

2011-08-23 02:05:17 EDT

Whenever I try to use running sum on crosstab (2.6.1) I get the following message:  "Aggregation on cube measure can not be such type: "RUNNINGSUM" I will add some attachment with more detailed description.

Comment 3 Tomas Greif

2011-08-23 02:29:45 EDT

Created attachment 201968 [details]
Running sum in crosstab - aggregation orientation and partitions

Simple example of running sum aggregation in crosstab. This kind of aggregation/partitioning would be really useful in financial management (PL by months/years) or in projects performance tracking.