Skip to Content
0
Former Member
Aug 02, 2016 at 03:24 PM

How to get first date and last date of previous month in a webi report dynamically

2707 Views

Hi I have a requirement in a webi report, i.e. if I run the report on today i.e. on 2nd august , I should get the data for the last month. So I need to set the filter in that way dynamically. Is there any way to achieve that without using prompt in query filter level, by creating objects in universe level??

I'm using UDT and my database is DB2.

Thanks,

Yaswanth.