SAP BW BEX "how to extract hours greater than"

[Former Member]

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

[Former Member]

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

[ccc_ccc]

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