cancel
Showing results for 
Search instead for 
Did you mean: 

Doubt in exception aggregation

Former Member
0 Kudos
45

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi there,

Why don't you let your key figure ZBALANCE be just SUM SUM (no exception aggregation), and in the query represent calculations of that key figure as cumulative (also in results).

This will retrieve exactly what you want!

Diogo.

Former Member
0 Kudos

Perfect!

Thank you.

Answers (0)