Scheduling Reports with Dynamic Dates

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 :ireland: (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 :ireland: (BOB member since 2006-03-30)