Skip to Content

How to filter report by Variables formula based

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 ? 
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Jan 10 at 10:40 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 21 at 09:21 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 21 at 04:24 PM

    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

    Add comment
    10|10000 characters needed characters exceeded