Skip to Content
0

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

Aug 17, 2017 at 02:03 PM

22

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Kuldeep Ghosh Aug 17, 2017 at 03:25 PM
0

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"

Share
10 |10000 characters needed characters left characters exceeded
AMIT KUMAR
Aug 17, 2017 at 02:34 PM
0

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?

Share
10 |10000 characters needed characters left characters exceeded