Former Member

# Exception aggregation in one CKF causing problem in Result row of other CKF

Here is my scenario in 3.5x BW:

I have a CKF A which has exception aggregation (to select maximum value) based on a reference characteristic..

Now this CKF A is used in another CKF B and a third CKF C is being calculated based on CKF B. SInce I am using exception aggregation in CKF A, CKF B and C had to be set to be calculated 'after aggregation'.

Formula for CKF C = 100*B/ D (D is another constant CKF, with value 1 for each row).

Now my requirement is that the result row of CKF C should be calculated using the same formula on result row of B and D. This was working when I was calculating A without exception aggregation. But now I need to use exception aggregation aswell as I want the result of C = 100 * Sum(B)/ Sum(D).

I have tried the alternative of using a Formula selection (with formula collision - Result from this Formula)instead of CKF for calculating 'C', but didnot find any success in getting result row of C as per my requirement.

Any suggestions in resolving the issue will be higly appreciated..

Thanks

Shikha

10|10000 characters needed characters exceeded

• Posted on Sep 20, 2010 at 12:54 PM

create a new CKF A' without aggregation. use this CKF in a new CKF B'.

adapt the formula of C to C : KF C = 100*B'/ D

10|10000 characters needed characters exceeded
• Mario Tibollo Former Member

you have created a calculated key figure A in your query, and in the properties of this calculated key figure you have defined the exception aggregation right?

so you can create a second calculated key figure (say A') with the same definition as ckf A, but you don't put any exception aggregation in it. then you need to create a second calculated key figure (say B') to replace the calculated key figure B, and use ckf B' in this new ckf.

when you use now the calculated key figure B' in the formula of ckf C, it should be correct as you use ckf A' as basis, which has no aggregation...

quite straight forward, no?

M.

• Former Member
Posted on Sep 21, 2010 at 12:09 PM

Hi Shika,

if at all you want to use exception aggregation for key figure A. there in the backend you can do that. go to the info obejct -> Aggregation tab-> mention there the type of aggregation and the characteristic on which it should happen.

but the problem with this is, if other reports using that would be affected. in that case you may create a new info object of that type and fill that in cube and use it. you need not have to worry now abt the exception aggregation on report level.

hope this helps you .