Rolling Date Filter

[matix10]

Hi All,

I want to apply rolling last 3 years data filter in my report. I have gone through the available threads and tried to implement it but not able to get the expected result.

I have to rolling filter data from current date to last 3 yrs data. Can somebody please help me with this?

Thanks in advance!

[matix10]

Hi amit.kumar71 ,

Could you please help me with this ?

Thanks in advance 🙂

[amitrathi239]

what is the backend database?

[matix10]

Hi amit.kumar71 , It is oracle database

[amitrathi239]

You can do through creating 3year back date object in the universe.

After that add the webi filter where Date object is between 3year back date and sys date object.

e.g.

add_months( trunc(sysdate),-36)

[matix10]

I am not supposed to do anything in UDT. I need these changes to done at Webi level only.