Skip to Content
0
Former Member
Jun 26, 2008 at 04:22 PM

Key Figure Aggregation

30 Views

Hi All,

I need to understand how the InfoObject 0BALANCE aggregation works.

It is set to:

Aggregation: SUM

Exception Aggregation: Last Value

Agg.referen.char: 0FISCPER

My understanding is that the query will show the "0BALANCE" value in a Fiscal Year Period (0FISCPER)

For example, the cube contains

CUSTOMER FISCPER 0BALANCE

1 01.2007 10

1 03.2007 20

2 02.2007 1000

2 04.2007 20

3 07.2007 10

The query will display

CUSTOMER 0BALANCE

1 20

2 20

3 10

Is this correct?? Also, what would happen if there were multiple values for a period. See below. I presuming the aggregation would not be a valid for this scenario?

CUSTOMER FISCPER 0BALANCE

1 01.2007 10

1 01.2007 20

Many thanks in advance.

Leo