InfoView - Query Filter for date variable of previous week

[Former Member]

I am trying to automate the process to generate a report for the previous week's data. Right now I just prompt the user to enter in the start & end date/times, but I would like to somehow automate the date filtering using a Query Filter.

In particular, the report will be generated every Thursday at 12:35 PM, and it needs to filter only the date field between the date's of the previous Thursday @ 1:31 PM, and the current Thursday @ 12:30 PM.

I know there is a way to do this using an offset or something like that, but I'm a bit of a newbie to InfoView....so any help is greatly appreciated. Sorry if the explanation is confusing.

Thanks so much,

Nick

[amitrathi239]

Hi,

You can create two objects on universe level or first database level then add in the universe based the sysdate.

Then go to webi query and replace the prompt value by these objects and from next time when ever user refresh this report will run without any prompt.Same thing in the scheduled report.

Thanks,

Amit