Skip to Content
0
Former Member
May 27, 2009 at 03:52 PM

Doubt in exception aggregation

23 Views

Hi Gurus.

I'm having a problem to create a specific report here. To simplify.

I have a .CSV file similar to:

0GL_ACCOUNT; 0FISCPER;ZBALANCE;

0011025002; 0032009; 10;

0011025002; 0032009; -10;

0011025002; 0032009; 10;

0011025002; 0042009; 10;

0011025002; 0042009; 10;

0011025002; 0042009; 10;

0011025002; 0052009; -30;

And the data above flows to an InfoCube.

I want to make a report with the balance for each fiscper. And the balance have to be cumulative. For example:

Mar/2009 Apr/2009 May/2009

Account 0011025002 10 40 10

The balance at the end of march is +10. Adding the balance of april, the total goes to 40, and adding balance of may, it decrease to +10 again...

I'm working with (in ZBALANCE key figure):

- Aggregation = SUM

- Exception Aggregation = Last Value

- Agg. Reference Char. = 0FISCPER

But it doesnt work. It dont acumulate the balance from last month with the result of the actual. The report show the balance of each month separately.

Does anyone know how can I make a report like the example above?

Regards,

Thiago