Custom Filter on Webi XI 3.1

[system]

@Nisha Singh

Yes, want to get it created in the universe so that other reports could also use it.

[Moderator Note: So moving from WebIntelligence XI to Semantic Layer / Universe Designer]

@Nisha Singh

Ours is SQL Server 2008

Then this sticky topic can be helpful:

DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2

As per this topic on Oracle relative dates, here’s the same set of dates in SQL Server. Please note that some may not work on SQL Server 2000, but all definitely work in 2005/8. Yesterday cast(convert(char(10),dateadd(d,-1,getdate()),23) as datetime) Today cast(convert(char(10),getdate(),23) as datetime) The following also works for today: dateadd(dd, datediff(dd,0,getdate()), 0) Start of Current Month cast(convert(char(7),getdate(),23)+'-01' as datetime) End of Current Month dateadd(d,-1…

@Nisha Singh

Was trying this : ((@Select(Installment Facts\Record Written DT Display))= (GETDATE() -1))

Did not work

Why was it not working? Did you get wrong results? Did get an error message?

---

Marek Chladny (BOB member since 2003-11-27)