on 08-24-2018 7:01 AM
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.
Hi,
Can you provide a sample report with your desired RESULT?
Regards,
Loed
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.