Addition keeping values of key figure in query designer

[former_member254358]

Hi,

I would like to know whether it is possible to control which key figure will be summed or not in and aggregation (depending a characteristic).

For example,

KUNNR           PLANT  MATNR  KF1  KF2  KF3

=====================================

0000000001               1  mat1      4       7      45   

0000000001               1  mat2      4       7      68

If I aggregate by KUNNR and PLANT in the query the result is the following:

KUNNR           PLANT  KF1  KF2  KF3

=====================================

0000000001               1  4       7      113

Can anybody help me?

Thanks in advance.

Regars.

[former_member186053 · Accepted solution]

Hi David,

Are the KF1 & KF2 defined with exception aggragation, please check. you can change the aggregation behavior of key figure with exception aggregation based on characteristic. Compare the three KFs aggregation.

Regards,

Vengal.

[former_member254358 · Accepted solution]

Sorry I think I didn't explain correctly.

Changing the example:

KUNNR           PLANT  MATNR  KF1  KF2  KF3

=====================================

0000000001               1  mat1      4       7      45  

0000000001               1  mat2      4       7      68

0000000001               2  mat3      5       9      12  

0000000001               2  mat6      5       9      8

0000000001               2  mat8      5       9      5

aggregating by KUNNR and PLANT (with subtotals and total)

KUNNR           PLANT     KF1  KF2  KF3

=====================================

0000000001               1       4       7      113  (SUBTOTAL 0000000001 + 1)

0000000001               2       5       9        25  (SUBTOTAL  0000000001 + 2)

                                                9       16    138  (TOTAL)

I mean KF1 & KF2 keeps equals for the same KUNNR and PLANT. And KF3 behaves normaly.

Thanks.

[Former Member · Accepted solution]

Hi David,

Does the KF1 and KF2 values against material are always same (from your example)?

please check if calculated single value as chosen 'average/max/min ' from calculation tab of key figure for both KF1 and KF2 ?

[former_member254358 · Accepted solution]

Yes they are always the same. Both KF only depends on KUNNR and PLANT.

[Former Member · Accepted solution]

ok, If I understand correctly, KF1 and KF2 values are depends on KUNNR and PLANT irrespective of material ?  you can change both key figures calculation to summation, if you want to see the the aggregated values.

[former_member186053 · Accepted solution]

Hi David,

How is the data is showing in underlying infoprovider of this query with both KUNNR and PLANT combination.

I suspect, exception aggregation might be defined for both KF1 and KF2.

Regards,

Vengal.

[former_member254358 · Accepted solution]

Exactly.

But I don't want to see KF1 and KF2 aggregated in case KUNNR and PLANT would be the same, jut the opposite.

I think it is what you said before, exception aggregation,.

[former_member254358 · Accepted solution]

Hi,

in the infoprovider there is a combination of KUNNR, PLANT and MATNR.

I could change infoprovider if it is necessary.

I'm looking information about exception aggregation to see if it fix my problem.

Thanks..

[former_member254358 · Accepted solution]

Please, could you tell why "exception aggregation" is disable in tab aggregation?

Thanks.

[former_member254358 · Accepted solution]

I'm trying with the exception aggregation but it's disabled.

How can I enable this option?

Thanks.

[Former Member · Accepted solution]

Hi David,

Exception aggregation is enabled only for Formula/Calculated key figure .

Also, from your example, I am not seeing KF1 and KF2 are aggregating, are you talking about total result here?

aggregating by KUNNR and PLANT (with subtotals and total)

KUNNR           PLANT     KF1  KF2  KF3

=====================================

0000000001               1       4       7      113  (SUBTOTAL 0000000001 + 1)

0000000001               2       5       9        25  (SUBTOTAL  0000000001 + 2)

                                                9       16    138  (TOTAL)

[former_member254358 · Accepted solution]

Hi Jyothi,

yes I'm talking about total result.

I used exception aggregation with two characteristics, because in addition to matnr I have another characteristic, and 'Minimum' and it doesn't work fine in the whole cases and I don't know why.

Is the Minimum the correct function to be used in this cases?

Thanks.

[Former Member]

Hi David,

Exception aggregation will not work on direct key figures in Query level . You need to create a formula/ CKF to have the feature of exception aggregation.

Now for  the  Keyfigures KF1 & KF2, check in the backend in the Keyfigure level its having any aggregation property mentioned, If its summation then it should work in the Query level as Expected.

[former_member254358]

Hi Viveklal,

the KF1 & KF2 have summation in the backend in the key figure.

Now I'm using exception aggregation with two characteristics but the results are not the expected in some cases.

Thanks.

[Former Member]

Hi David,

For total result --> you can choose "calculate result as" -->summation from calculation tab of both key figures.