Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

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

    max-logic-sample-data.png

    Hi Folks,

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

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 11, 2017 at 05:56 AM

    hi,

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

    Regards,

    anand

    Add comment
    10|10000 characters needed characters exceeded