CKF Result Row / Aggregation Problem

[Former Member]

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 > 😎 * (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,

[Former Member]

Hi Gurus,

I have a similar problem as you discuss. We have a query as below which calculate C column as A/B.

A B C

C1 5 2 2,5

C2 8 4 2

C3 10 5 2

Result 23 3.36 2,09 .

The result row of A is a summation (5 +8 +10 = 23 ) .It runs OK.

The result row of B is average ( ( 245 )/3 = 3.36 ) .It runs OK.

The result row of C should be 23 / 3.36 = 6.84 . But we are not able to run it. It should not be 2.09 or another result.

Is it possible to make this calculation in the result row of C column ?

I would be gratefull.

[Former Member]

Hi Brendon,

No need of any exception aggregation.

just leave it as standard aggregation, it will work automatically.

Don't change any aggregation settings.

Thanks

Tulsi

[Former Member]

hi,

try using exception aggregation as summation reference to employee id on F1.

Also set the function calculated result as summation in the properties of query.

REgds,

Shashank

[Former Member]

Hi Brendon,

Have you got the solution of your issue...i am also having the same problem?

Regards,

Pravin.

[Former Member]

hi,

i hope if you have used the structure and cell restriction hope you could solve ur issue.

Ramesh