Skip to Content
0

How to filter report by Variables formula based

Jan 10 at 09:53 AM

42

avatar image
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 ? 
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

AMIT KUMAR
Jan 10 at 10:40 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Silvia Vendrame Jun 21 at 09:21 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Noel Scheaffer Jun 21 at 04:24 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded