List of values for prior period

[Former Member]

I would like to schedule a daily report for 3 different date range criteria.report runs every day.It should produce data separately for last 24 hours ,48 hours and 72 hours separately.i would like to avoid manual schedules with start date and end date.One report should work for last 24 hours ,48 hours and 72 hours separately.So ,I would like to create an object in the universe which will produce list of values for Prior day ,last 2 days and last 3 days .

I am also looking for last week and last month(optional) .Could you please suggest me the best approach for this

other wise i have to go for 3 individual reports which will work for last 24 hours ,48 hours and 72 hours

The database I am using is oracle.Business Objects is 4.0

[nscheaffer]

Do you have access to the universe or can you make a request for an addition? I would recommend a filter in the universe with a prompt that asks you how many hours you want to go back. I have something similar with respect to a filter that I call Relative Days. This is the where clause on that filter...

CONVERT(DATE, DATEADD(DAY, @Prompt('Number of days:','N',,Mono,Free,Not_Persistent,,User:0), GETDATE())) = Common.dbo.Calendar.dt

When I include that in a WebI report I get prompted for how many days I want to deviate from the current date. A value of "-1" returns yesterday.

Does that help at all?

Noel

[Former Member]

Perhaps this can be useful.

Regards,

Rogerio