Skip to Content
avatar image
Former Member

Report to be run for 2017. what should be the logic behind this in WEBI.

Report to be run for 2017... instead of giving january to august data... report should give the data from jan to july... what should be the logic behind this in WEBI.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 17, 2017 at 03:25 PM

    If you have a date object in your universe, simply pull the date objects in the query panel. Insert the objects like

    [Date Object] between "Start Date" and "End Date"

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 17, 2017 at 02:34 PM

    you need two objects in universe.

    Year First date and Previous Month last date objects.Once you have then you can use in the webi query filter.

    what is your backend database?

    Add comment
    10|10000 characters needed characters exceeded