How to restrict webi report data by default to previous day
Hi ,
This document will be helpful in cases where we need to restrict by default to previous day /last seven days in webi report . This document will be helpful mostly in cases when we don’t have universe access and need to schedule webi report by default to certain period (previous day/last 7 days etc) .
Sample data :
Here Emp doj object is the date object used
Req: User want to see details of number off employess joined in previous day & last 7 days .
This can be achieved by creating objects at universe by calculating today -1 & today using calendar objects . If we don’t have universe access and want to achieve same at webi report then this can be achieved as below.
Create variable by using daysbettween & Current date function as below using Emp doj.
Now this variable will give you difference of days as below
Now use created variable and restrict above table /block with -1 for previous day data & -1 to -7 for last seven days data as below.
Output :
Same way we can achieve for last 7 days by restricting table /block with Daysbetween inlist(-1 to -7).
If we schedule this report by default it will fetch previous day values as we are getting now and it is dynamic i.e based on current date previous day values will be calculated and in report it will show previous day values only.
Note : It is recommended only when we have less volume of data
Hope this document will be helpful for some one.
Any suggestions/comments welcome .
Thanks