How to filter report by Variables formula based

[former_member298280]

I have a SAP BO 4.1 report having warehouse movements.
Thny need to schedule some instances extracting the documents posted in thellast 7 days.
How can I do ?
I've the document posting date as query field, but:
1. I'm not able to use formulas, like CurrentDate(), VariableDate(CurrentDate();-7) as prompt values;
2. I'm not able to use Variables I've defined based on above formulas to enter a report filter ....Any idea ? 

[nscheaffer]

I built a Calendar universe a few years ago to address this very issue. I then add my Caledar universe as a secondary query and link to it from my primary query. Here is how I did it...

https://blogs.sap.com/2014/02/11/first-day-of-previous-week-with-a-twist/

Hope this helps,

Noel

[former_member298280]

Hi Amit,

we fixed using a variable returning true/false if the posting date is inside/outside the interval.

Then filtered the record according to this variable value.

Thank you

Silvia

[amitrathi239]

what is your back-end database? you need to create filter in universe to get everytime date -7.after that you will not get the prompt in webi scheduling to enter the date range to get the values.