Dynamic Filter in webi on Date

[Former Member]

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.

[nscheaffer]

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

Noel

[sateesh_kumar1]

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&#...