PROBLEM WITH RECORD AGGREGATION

building reports webintelligence
1

Why is the amount of one record not being added up in SUM AMOUNT (an object in universe) whenever that record has the same dimensions and measure as another record? Such record is really not a duplicate. It just happens to have the same dimensions and measure (AMOUNT).

For example,
YEAR ACCOUNT AMOUNT
2008 LMNO 200.00
2009 ABCD 100.00
2010 WXYZ 150.00
2010 WXYZ 150.00

The result I get is:
YEAR ACCOUNT SUM AMOUNT (universe object)
2008 LMNO 200.00
2009 ABCD 100.00
2010 WXYZ 150.00

My expected result is:
YEAR ACCOUNT SUM AMOUNT (universe object)
2008 LMNO 200.00
2009 ABCD 100.00
2010 WXYZ 300.00

What is causing the error? What should I do to get the expected result?

Thanks in advance!

ANIVID (BOB member since 2009-09-12)

2

Hi ANIVID

Do this measure object has Sum in the Projection.

I think it has None so its not getting aggregated.Check it once.

rak_2010 (BOB member since 2010-05-01)

3

I am new to Business Objects. Where can I find PROJECTION so that I can change it to SUM instead of NONE?

ANIVID (BOB member since 2009-09-12)

4

Hi,

Is SUM AMOUNT object really a measure? Is it not a dimension. From how you described it it looks to me that the object could be a dimension.

You need to check it in the universe, in Designer.

Marek Chladny :slovakia: (BOB member since 2003-11-27)