Skip to Content
0

MAX reading value for the month and reading document date and time required bw bex query

Jul 10, 2017 at 07:21 PM

68

avatar image
Former Member
Dear Folks,

I need to show Max reading value for the month which is max reading document date and time in column level.

for achieving max reading used exception aggregation with reference characteristic document number, for same logic applied for date and time key figures. query result working max document date and max time. how can I achieve max reading value corresponding date and time required. it very urgent requirement for us

sample data

PlantDOC NODatetimereading values20001000001.07.201713:00:0045 amps20001000102.07.201717:20:0020 Amps20001000203.07.20171:00:2024 Amps20001000304.07.201712:56:3450 Amps20001000405.07.201710:00:1212 Amps

need result like below.

PlantMax Reading valuesDateTime200050Amps04.07.201712:56:34

But applied exception aggregation on Reading values with reference char. document no same for date and time

result with worng values.

PlantMax Reading valuesDateTime200050Amps05.07.201717:20:00

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

avatar image
Former Member Jul 10, 2017 at 07:33 PM
0

max-logic-sample-data.png

Hi Folks,

Kindly refer attached document my requirement with sample data, expected result and actual getting result.


Share
10 |10000 characters needed characters left characters exceeded
Anand Kumar Jul 11, 2017 at 05:56 AM
0

hi,

did you try exception aggregation only on key figure value instead of date and time?

Regards,

anand

Share
10 |10000 characters needed characters left characters exceeded