Skip to Content
author's profile photo Former Member
Former Member

Dynamic Filter in webi on Date

We have a webi report which is scheduled on the date filter which is set on sysdate - 1 at the universe level. but some times we have to execute the report on the different filter value like sysdate - 2 or sysdate - 3 etc. currently we are changing the webi query manually from sysdate-1 to sysdate-2 etc... how could we define dynamic filter in webi or in universe.

Universe filter Definition :

"FRTU_FPI"."DATUM" = (select to_char(sysdate-1,'yyyymmdd') from dual)

we don't have any sysdate at universe level.

want to this changes dynamic rather changes the webi SQL.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Dec 16, 2015 at 02:45 PM

    HI ,

    we have function to get the current date in universe .

    Ex : sysdate/DATE/today depends on database .

    your requirement can be achievable , go through below blog .

    Dave’s Adventures in Business Intelligence » Using a “Magic Date” Value in Promp…

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 16, 2015 at 04:22 PM

    I created a dedicated Calendar universe to address situations like this. Check it my write up here...

    First day of previous week with a twist

    Noel

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.