I have created a calendar for a report to run on the Particular days. The Report itself has an end date prompt.
Is it possible to have the end date to be dynamic so when the Report that is scheduled
On 30th Jan …the report is run with the End date of 1st Jan
On 2nd Feb … the report is run with the End date of 31st Jan
On 6th Feb … the report is run with the End date of 4th Feb
etc…
Many thanks for any help
Sims
Sims786 (BOB member since 2006-04-04)
You will need to build objects in your universe for your required end dates.
These objects would use today’s date as a basis for determining each of these dates. The syntax of these objects would depend on the underlying database.
Let me know what database platform you are using and perhaps i can get you started?
jemstar 
(BOB member since 2006-03-30)
Hi
Thanks for that…if you help start that would be
Greatly appreciated. We Using business objects 3 and
Our DWH is on SQL box …
Again many thanks
Zahed
Sims786 (BOB member since 2006-04-04)
Examples of universe objects for SQL Server
Today
DATEADD(DAY, DATEDIFF(DAY, 0, GETDATE()), 0)Last day of previous month
dateadd(ms,-3,dateadd(mm,0,dateadd(mm,datediff(mm,0,getdate()),0)))First Day of Current Month
dateadd(day, datediff(day, 0,DATEADD(s,0,DATEADD(mm, DATEDIFF(m,0,GETDATE()),0))), 0) Date x days ago (using prompt)
dateadd(day,datediff(day,0,dbo.fn_adjusted_date(DATEDIFF(s,'1970-01-01 00:00:00', GETDATE())))+@Prompt('No of Days to Add ?','N',,Mono,Free,Persistent) ,0)You should get some ideas from these. Google will help you along…
jemstar (BOB member since 2006-03-30)