WEBI Recurring Instances to run for previous month

[system]

I am using WebI3.1 and Report has date prompts (Start & end dates). To create an Instance I am giving date prompts. However, How to create Recurring WEBI Instances first day of every month to run for previous month . Please help me in writing Report variables /universe level conditions?

---

Naveen Vanaparthi (BOB member since 2008-07-02)

[MarkP]

Create a scheduled version of the report and use universe objects created with relative dates. There is a sticky topic in the Semantic Layer section that caters for different databases:

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…