cancel
Showing results for 
Search instead for 
Did you mean: 

exception aggregation on multiple characteristics

dinesh_smhdr
Participant
0 Kudos

i have a requirement to calculate exception aggregation on multiple characteristics .

PartNo has multiple toolnumbers

toolnumbers has multiple supplier numbers .

And then keyfigure values which are same for all records. Like below

partnumber - P1

toolnumber - T1 T2 T3

suppliernumber S1 S2 S3 S4 S5 S6

KF - 1111 1111 1111 1111 1111 11111 11111 1111

On bex query , i have Partnumber and Toolnumbers with keyfigure values .

here the values are getting aggregated since supplier number was not added to the rows.

I need to exception aggregate the keyfigure values with all the 3 characteristics . But i do not want to take suppliernumber in rows. Please suggest.

Accepted Solutions (0)

Answers (2)

Answers (2)

Loed
Active Contributor
0 Kudos

Hi,

Can you provide a sample report with your desired RESULT?

Regards,

Loed

EVP
Employee
Employee
0 Kudos

Hi Dinesh,

Depending on your BW version you can choose multiple "reference characteristics" so you can put up to 8 characteristics as reference to the exception aggregation of you choice.

I would suggest then to put suppliernumber as the reference characteristisc as it is not going to be in the rows. Regards,

Eduardo