Skip to Content
author's profile photo Former Member
Former Member

CKF Result Row / Aggregation Problem

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,

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on May 07, 2008 at 06:03 PM

    hi,

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

    Ramesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 29, 2008 at 11:15 AM

    Hi Brendon,

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

    Regards,

    Pravin.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 29, 2008 at 12:09 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 29, 2008 at 01:25 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 17, 2008 at 12:49 PM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.