Skip to Content
avatar image
Former Member

SAP BW BEX "how to extract hours greater than"

Dear sirs,

In my BEX reports I would like to extract lines greater than 5:00 PM.

For each line I have a result that contains "End Time" but I don't know to extract only end time > 5:00 PM.

Do you have an idea how to create this condition.

Regards,

Marc

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 08, 2015 at 03:58 PM

    Hi Marc,

    Approach 1:

    1. Keep TIME infoobject in ROWS
    2. Create New Formula Called Time and double click new formula
    3. Under Time formula , create new formula variable
    4. General tab-->Processing by "Replacement path" ,Reference char --> select time infoobject
    5. Replacement path tab-->offset setting offset start 0 offset length 2
    6. Currency/unit tab-->Dimension -->number
    7. Double lick on newly created formula variable
    8. goto condition-->General tab-> select formula (time) grater than value 5
    9. Characteristic Assignment Tab-> select only "Time infoobject"

    Execute query, you can see desired result.

    Thank you,

    Nanda

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 09, 2015 at 04:47 AM

    Hi MARC,

    There is one easy way to handle this condition.

    Just follow this step,

    1) End Time should be in ROWS

    2) Create New Formula End Time and double click new formula

    3) create new formula variable with Replacement path and select info object "End Time"

    4) Replacement path tab-->offset setting offset start 0 offset length 2

    5)Currency/unit tab-->Dimension -->number

    6)Create one condition in Bex designer,

    7) And click on New and provide KF (End Time) & Oprand '>' and value = '5'.

    Please check attached screeshort

    Hope this helps,

    Chandresh


    condition.jpg (71.1 kB)
    Add comment
    10|10000 characters needed characters exceeded