Skip to Content
Author's profile photo SESHA PS

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 :

a1.PNG

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.

a2.PNG

Now this variable will give you difference of days as below

a3.PNG

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.

a4.PNG

Output :

a5.PNG

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

Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.