CKF Result Row / Aggregation Problem

38 Views

Hello all,

I am having a problem with my result row for a Calculated Key Figure. I am using BW3.5 Query Designer. My Query looks like this:

0CALDAY 0EMPLOYEE ZSUM_HRS HRS>8(F1)

Where F1 = (ZSUM_HRS > 8) * (ZSUM_HRS-8). Therefore if ZSUM_HRS = 12, then F1 = 4. I would always like the result to be based on 0employee. I set the calculate result as "Summation".

0EMPLOYEE ZSUM_HRS (F1)

1......................8..............0

2......................9..............1

3......................12.............4

4......................8..............0

5......................9..............1

R.....................46.............6

Now, I have a ZDEPT drilldown, where employee's belong to a department. If I add the ZDEPT drilldown, and remove the 0EMPLOYEE drilldown, my result row does not show the proper values. For example:

ZDEPT ZSUM_HRS (F1)

1.....................46.......38

(F1) = 46-8 = 36.

However, I would like the result to be equal to 6. Can I solve this problem via Exception aggregation on the base key figures that make up ZSUM_HRS?

Thanks,