Skip to Content
0
Dec 01, 2011 at 09:25 PM

Aggregation Problem on BEx Report

39 Views

I have a query that I want to display key figs that will aggregate.

For example:

char -> 0DF_PREQ

char -> 0DF_PREQITM

char -> 0pur_group

char -> pr_rlsdt

char -> zprrlsta

key_fig -> 0netprice

cal_key_fig-> z_mike_test

cal_key_fig -> ckf_mike_test

z_mike_test is defined as:

general calculation: abs(date1 - date2)

aggregation: std

aggregation reference_char: 'none'

calcuate after aggregation - checked

cal_key_fig is defined as:

general calculation: z_mike_test > 40

aggregation: std

aggregation reference_char: 0DF_PREQ

When I run it I get 8 rows. The days are calculating properly, and my counter displays 1 in the ckf_mike_test column for 6 of the 8 records so I'm all happy. 0DF_PREQ is unique for 6 occurrences (i.e. one 0DF_PREQ has 3 0DF_PREQITM)

However, when I take out 0DF_PREQ I get 7 rows and my counter displays 1 in the ckf_mike_test column for 5 rows. What I expected to happen is for one row to have a 2 in it, i.e. there should have been an aggregation still by 0DF_PREQ.

What am I doing wrong?

Mike