cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

CKF Result Row / Aggregation Problem

Former Member
0 Kudos

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,

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

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
0 Kudos

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
0 Kudos

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
0 Kudos

Hi Brendon,

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

Regards,

Pravin.

Former Member
0 Kudos

hi,

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

Ramesh