Exception aggregation in BEX

[Former Member]

In an ODS we have this situation:

ODA                     Item          Material         Supplier            n.supplier

450000197            10             2350             1000243              1

450000197            20            2350             1000243              1

450000198            10            2350             1000244              1

450000199            10            2350             1000243              1

We want to create a query with the material in rowns in this way

Material       N. supplier

  2350                2

we are not able to do this also with exception aggregation for KF 'N. supplier'. If we don't use exception aggregation obv we have the value 4 which is incorrect.

Regards

Luca

[Former Member]

actually it works also with your helpful answers. I've defined a new CKF with exception aggregation 'counter for alla detaile values' on the KF 'Supplier' and at first glance it looks fine.

Luca

[Former Member]

Hi,Luca Ferrario

You can restrict the KF's local calcute in the Query Designer 's calcute tab and set it as coutor

[Former Member]

create a CKF with Total exception aggregartion  with reference to field  supplier

[rathy_moorthy2]

Have u tried putting exception aggregation characterstic as 'supplier' in ur ckf?

Regards,

Rathy