Skip to Content
avatar image
Former Member

Specific time frame for reports Webi

Hello all,

I would like to run a report that brings in data when the [date] is between specific time frame- 8.00 to 6.00 PM. What formula can I use for this?

Thank you

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jan 24, 2017 at 04:28 PM

    Extract timepart in additional object in universe and add the webi query filter where timeobject greater then 8.00 and less then 6.00.

    if you want to do this at report level again same concept extract the time part in one variable and apply the report/table level filter to restrict the data.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 27, 2017 at 03:22 PM

    How do I extract the timepart from a datetime? Could you please provide suggestions.

    Add comment
    10|10000 characters needed characters exceeded