Reg; Webi Reporting Queries

[Former Member]

Hi Gurus.

1. How to add 6 months to the current date in Webi report..

2. My report is having last one year data, I want to display only one month report from the Sys date..

Regards

L k Vepuri

[Former Member · Accepted solution]

Relative months are poor in Webi. You're better creating something at the universe level. I've created a topic on the BOB forum that discusses relative dates in both SQL Server and Oracle:

http://www.forumtopics.com/busobj/viewtopic.php?t=152613

You need to be clear with your reporting requirement for a month since sysdate.

An example of what is done at the database level:

select DATEADD(mm,6,'2010-08-30')

returns '2011-02-28'

select DATEADD(dd,180,'2010-08-30')

returns '2011-02-26'

So while pumpactionshotgun has given you an approximation, there is currently no way for Webi to match a database's accuracy in relative months without massive high maintenance nested if statements.

[Former Member]

Hi,

Try this

=DATEPART(mm, [Order_date]) in (10, 11,12)

All the Best

Madhu.....

[Former Member]

What is that meant to do?

[arijit_das]

1.

=RelativeDate(CurrentDate();(30*6))

2. Which Database u r using? You can try to create the relative date object in universe itself and in the report apply a filter so that date in report is greater than the relarive date.